Fixing the issue Database ‘msdb’ cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926). In SQL Server 2008

The above issue occurred to me once I did a force shut down on my machine where I had MS SQL Server Manager working .Although I could query for the databases and tables, when I try to expand a database in the object explorer it gave me above error. There could be couple of reasons for this and error log should give you a hint what exactly caused the problem.

You can read more about what exactly msdb is from official page here. And there is an important  mark as “After any operation that updates msdb, such as backing up or restoring any database, we recommend that you back up msdb. “ which I missed to do and must have caused above.

Surfing through the internet provides you various methods of fixing starting from rebuilding system database in SQL server 2008 to reinstalling the application.

What instantly fixed my issue was to replace existing MSDBData.mdf & MSDBlog.ldf files in C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA. I got these 2 files copied from another working machine, Stopped the SQL service running in my machine, removed the above existing 2 files from their location and added the new 2 copied. Once I restarted the service ,  issues has been fixed.

Advertisements

19 thoughts on “Fixing the issue Database ‘msdb’ cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926). In SQL Server 2008

  1. thanks.
    in addition, i found that MSDB from SQL Server 2012 doesn’t work for recovering SQL Server 2008 R2 meanwhile MSDB from SQL Server 2008 does the trick.
    thus MSDB just might be version specific.

  2. Thank you!

    I copied these two files from C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Template Data. And it worked well.

  3. After upgrading from SQL Server 2008R2 to SQL Server 2012, the SQL Server service was not starting due to error 926 and 18401. I came across your blog and the issue was resolved as soon as I copied files from another server. Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s