[3417] MSSQL Express 2005 error due to compressed LDF/MDF
Today when I tried to start MSSQL EXPRESS 2005 on my laptop in which I have not started the SQL service for quite some time, I received the following error:
Windows could not start the SQL Server (SQLEXPRESS2005) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417.
And I found the following error detail in the Event Viewer (Windows XP: Start > Settings > Control Panel > Administrative Tools > Event Viewer > Application)
“The file ‘ C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mastlog.ldf ‘ is compressed but does not reside in a read-only database or file group. The file must be decompressed.”
Immediately the cause was known. As my laptop disk space did run low quite some time ago, Windows actually helped to compress the files that were not used frequently. MSSQL doesn’t know how to load compressed database files, as simple as that.
I simply browse to ‘ C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\ ‘, right click on ‘ mastlog.ldf ‘, proceed to ‘ Properties > General > Advanced ‘ and uncheck ” Compress contents to save disk space “
If that still does not solve your problem, try to do the same for all the files under that folder, that should do the trick.
Cheers!
1 Comment + Add Comment
Got anything to say? Go ahead and leave a comment!
Archives
- May 2012
- March 2012
- February 2012
- July 2011
- June 2011
- May 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- March 2010
- February 2010
- January 2010
- December 2009
- September 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008



Posted under:
[...] is the original post: adorr.net » [3417] MSSQL Express 2005 error due to compressed LDF/MDF Tags: following, have-not, Laptop, Ldf, mdf, quite-some, received-the, received-the-following, [...]