Thursday, May 19, 2011

SQL Database is compressed but does not reside in a read-only database or filegroup

If you get the next error when trying to access your database:

The file "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.





The problem is that the database file is compressed, to uncompress the database file:

  • Right click on it
  • Select properties
  • Click on the Advance button
  • Be sure the Compress contents to save disk space, is not checked