Master.mdf is Compressed But Does not Reside in a Read-only Database or Filegroup. The File Must be Decompressed.
August 6th, 2009 by Andrew Chen
I have not used the developer edition of SQL server on my laptop machine for a long while. When I try to turned on SQL server today I found it couldn’t start. When I check the event log there was an error message related to SQL server service like this.
“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 file group. The file must be decompressed.”
I remember the free space on my laptop machine was running low and windows ask me to compress the files that were not use frequently. So that was the reason cause this error. I looked at the property of the MDF and LDF files. At the advance tab the check box “compress content to save space” was checked. So I unchecked this box and save. After that SQL server can start without problem
Related Posts:
(10 votes, average: 5 out of 5)
Loading ...17 Comments
Sorry, the comment form is closed at this time.
You just saved me the biggest headache!
Thank you!
Cool, it just worked 4 me too…
Cheers
This happened on my SQL 2005 express instance which was installed with Backup Exec 12.5. All of the BE DB’s and Log files were marked for compression. You saved me a ton of time and headaches! Thanks!
Thank , this work
it works!thanks
You are a start … saved my time and head!!!
THANKS!
Work like a champ,
Thanks for your great topic,
SAVED ME A HUGE HEADACHE. GOOD CARMA TO YOU.
I got this error but Windows XP SP3 did not have the “Compress contents to save disk space” checked. So I unchecked the “File is ready for archiving” and “For fast searching, allow Indexing Service to index this file” as those were checked.
The error message was not seen after this.
Just an FYI.
Thank you very much, I’ve been scratching my head trying to figure this out on my own to no avail. Your post is spot on!
Thank you for saving my life from trouble
I’ve been searching for so long for a solution…THANKS SO MUCH..you helped me a LOT!!!
Friends,
If you are getting this error while the database is restored on new server,then you need to uncheck the box “compress content to save space” in advance option of the folder where you specified the location of the mdf file.
right click on the folder and go to properties and click on advance tab and u will check this option “compress content to save space”
For eg:
My location for mdf file in new server was “E:\MSSQL\SIGCAP\DATA” so i unchecked the box for folder “E:\MSSQL”
I successfully restored the backup.
Regards
Nizam
Тhanks for sharing уour thοughts abоut Random
thoughts and newѕ by Andrew Chen and friends.
Regаrԁs
It works.
saved me a lot of grief!
Thanks.
Sir thanks alot, It saved alot of time and worked like a charm