Error during restore:
Restore failed for Server '<servername>'. (Microsoft.SqlServer.Smo)
System.Data.SqlClient.SqlError: The file "e:\Db.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. (Microsoft.SqlServer.Smo)
WORKAROUND:
You can stop SQL Server service and then compress the data and log files of a read/write database. However, once you restart SQL Server, the read/write database will still be visible in your Management Studio, but if you try to access it, it will error. Uncompress the files and everything should go back to normal. Microsoft does NOT recommend that data or log files be hosted on compressed drives.
For more info, see; From Microsoft: http://blogs.msdn.com/b/sanchan/archive/2006/06/04/617585.aspx
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center