System.Data.SqlClient.SqlError The File MDF is compressed but does not reside in a read only database or filegroup

Question

System.Data.SqlClient.SqlError The File MDF is compressed but does not
reside in a read only database or filegroup.The file must be decompressed when I resotore Database in SQL Server 2005.

With Regards
Bvenkat Jeewesh
S/W Developer

Sandeep Pant · Answer

Try this : open your .mdf file properties dialog box and in the advance tab check if the compress content checkbox is checked or not if it is checked uncheck it and save changes . hope this solves your problem