msdb Corruption on Small Business Server 2008

Problem:

A server crashed from an abrupt power reset.  The server needed to have the System State restored from a backup.  When the server came up, the SQLEXPRESS service would not start.  This was the first of a couple of problems.

Solution:

The first thing to do is to replace the files in the data directory, C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\.  rename the old data directory and copied in the new one.  After this the service started.

When opening the Open SQL Server Management Studio (SSMS).  When you click on the database node, it an error that states “database msdb cannot be opened it has been marked suspect by recovery”.  Then after attempting several things including repairing the install and recreating the databases from scratch, but neither worked.  Ultimately leading to us restoring the msdb database from a backup.

Restoring the msdb database from a .bak backup

– Open SSMS

– New Query

USE master

GO

RESTORE DATABASE [msdb]

FROM DISK = ‘C:\Temp\DATABASE_msdb.bak’

WITH REPLACE

GO

– Execute

Once this is done the database node will open correctly.