Udooz!

After a long while, I tried to start SQL Server in my home laptop.  It throws the following error message in the event log:

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.

Click here to cancel reply.