Thanks to dearest NRZ – my hero!

 

Two days ago,  there was a power trip at my office and that incident became the cause of my troubles this morning.

For one whole morning, I could not connect to SQL Server 2008 Management Studio because my msdb (which stores SQL Server jobs) was corrupted.

The error message was:
”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)”

I called my expert NRZ straightaway of course and complained to him about my problem.

Of course, NRZ  came to my rescue immediately and started Googling for solutions to help me.

At 11:08 am, he sent me his first link, which required working in cmd mode. Tried the instructions, but it just didn’t work!
http://sqlplanet.blogspot.com/2008/07/recreate-corrupt-msdb-database.html

At 11:25 am, he sent me yet another link which was using the SQL Server Configuration Manager in GUI mode.  Still didn’t work :(
http://rip747.wordpress.com/2008/05/26/rebulding-msdb-in-sql-server-2005/

At 12:11 pm. problem was still unresolved, so he sent me a third link.  Unfortunately, that still didn’t solve the issue.
http://paradisj.blogspot.com/2008/08/sql-server-error-detaching-msdb.html

After these numerous attempts and my urgency to get the SQL Server working so that I could work on my system, I told him I wanted to give up and just reinstall the whole SQL Server.

NRZ told me not to give up yet.

At 12:25 pm, he sent me another email. Attached to the email was a copy of the MSDBData.mdf.

And that proved to be the saviour of the day because when I copied and pasted this file to override my corrupted one, everything started to work well miraculously!

Thank you NRZ for patiently helping me with this problem today, my darling SQL DBA expert! :)