Archive

Posts Tagged ‘decompressed’

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.

February 18, 2014 2 comments

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!