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.

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:

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 )

Connecting to %s

%d bloggers like this: