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.

Share This: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
Tags Tags:
Categories: Uncategorized
Posted By: udooz
Last Edit: 14 Nov 2008 @ 12 10 PM


Responses to this post » (2 Total)

  1. (Mark McDonald) says:

    out of all the internet – you were the only post on this issue! Thanks! It help!

    Reply to this Comment
  2. (udooz) says:

    welcome mark

    Reply to this Comment
 Comment Meta:
RSS Feed for comments
TrackBack URI
\/ More Options ...
Register an account
Change Theme...
  • Users » 1
  • Posts/Pages » 60
  • Comments » 70
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight


No Child Pages.