Dive into the archives.
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!

I received three warmhearted W3 Silver Awards today, awarded by International Academy of the Visual Arts, an assembly of leading professionals from various disciplines of the visual arts dedicated to embracing progress and the evolving nature of traditional and interactive media.
The three winning websites are: mysingapore.sg, yesterday.sg, singapore2010.sg (was face-lifted), in which I was involved in site planning, and in-charged of the rest of the development, deployment, testing cycle.
Special thanks to Convertium and Gerard Lim for the opportunities, ex-tech manager for the unconditioned guidance and supports, project managers for excellent collaborations, and the designers for the brilliant creativity, and not forgetting the awesome clients MICA, NHB and MCYS.
I gladly and truly appreciate the recognitions, it seems like all the hard works being paid off.
This year is definitely going to be a better year!
Cheers!


