Advertisements
Home > Sql Server > The file is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally.

The file is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally.


Problem : The file is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally.

The file “<file.mdf>” is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. Restore database is terminating abnormally.

Cause:

This is because, a read/write database [.mdf and .ldf] files cannot be created on a compressed drive/directory. [Compressed directory/drive is in blue color.]

Solution:

-De-compress the drive/data directory by Right click on “DATA” directory
-Click Advanced
-Uncheck “Compress contents to save disk space”

Hope it helps!

 

Advertisements
  1. Kaushik Roy Chowdhury
    September 17, 2017 at 7:04 pm

    Great! It worked for me on VS 2015 MVC 5 (.Net framework 4.6) Thanks

  2. Kaushik Roy Chowdhury
    September 17, 2017 at 7:05 pm

    Great worked for me .

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: