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

SQL September 17, 2011 Comments: 2

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.

2 thoughts on “Compressed but does not reside in a read-only database or filegroup. The file must be decompressed.”

  1. prashanth June 11, 2013 at 2:41 pm Reply

    Is there any solution for it?

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

    @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”

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s

%d bloggers like this: