Archive for November, 2008

 14 Nov 2008 @ 12:10 PM 
 

Issue: SQL Server 2005 Failed to Start – master.mdf is compressed

 
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.

Tags Tags:
Categories: Uncategorized Posted By: udooz
Last Edit: 14 Nov 2008 @ 12 10 PM

Email • Permalink • Comments (2)
\/ More Options ...
Last 50 Posts
Back
Register an account
Change Theme...
  • Users » 1
  • Posts/Pages » 54
  • Comments » 39
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight