Home > SQL > Compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

Compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

Reason:-

Because of  read/write database’s primary .mdf and .ldf files cannot be created on a compressed drive. When you try to create a database on compressed drive or restore it from the compressed drive you will above error.

Advertisements
Categories: SQL
  1. prashanth
    June 11, 2013 at 2:41 pm

    Is there any solution for it?

  2. kouzoulos
    June 15, 2014 at 4:29 pm

    @prashanth

    Yes, there is one:
    De-compress the drive/data directory.

    Right click on “DATA” directory

    Click Advanced

    Uncheck “Compress contents to save disk space”

  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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

%d bloggers like this: