Friday, November 14, 2008
Issue: SQL Server 2005 Failed to Start - master.mdf is compressed
Posted by udooz at 11/14/2008 11:40:00 PMAfter a long while, I tried to start SQL Server in my home laptop. It throws the following error message in the event log:
When I opened the files in my $$SQL SERVER$$\DATA folder, all are getting compressed. It might be by Disk Cleanup utility. I just let the tool to compress old items. Huh!
I disabled the compress mode of these files by select all files -> righ-click -> Properties -> Advanced -> deselect Compress contents to save disk space.
After that I started SQL Server, it was started well.
The file "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
When I opened the files in my $$SQL SERVER$$\DATA folder, all are getting compressed. It might be by Disk Cleanup utility. I just let the tool to compress old items. Huh!
I disabled the compress mode of these files by select all files -> righ-click -> Properties -> Advanced -> deselect Compress contents to save disk space.
After that I started SQL Server, it was started well.
Subscribe to:
Post Comments (Atom)
3 comments:
out of all the internet - you were the only post on this issue! Thanks! It help!
welcome mark
Post a Comment