Author Options:

Msdb no longer exists? Answered

I have a problem with the hard drive on which was Windows 2008 SBS server. Drive is faulty and no longer works. I was able to restore Windows 2008 SBS server but the SBSMONITORING msdb no longer exists. Backup no. What you can do in this case?

6 Replies

GeorgeFinlaysonBest Answer (author)2017-01-26

Try install
a new SQL instance called "Junk" and then copy the msdb files over to
the SQL data directory for SBSMonitoring and then restart SBSMonitoring.
Then run the script detailed in the
article on Technet which will recreate the SBSMonitoring database.

The key to
fixing this problem is to restore the msdb mdf and ldf files from a new SQL

If so you
cannot restore a database then you can try to make sql mdf file repair. For
this you can try to use the MDF Repair
. On the website you can read more on how to do it. Sometimes this way
helps me when there is no backup or no
serious damage. http://www.mdf.repair/

Select as Best AnswerUndo Best Answer

ArturKis (author)2017-01-26

Thank you guys for your feedback and help. Thank you!

Select as Best AnswerUndo Best Answer

ThirdEarthDesign (author)2017-01-25

In these cases data loss is normally inevitable, but as this is only the SBSMONITORING SQL instance it really won't matter. You do have some options as the msdb can be rebuilt, you can also take another SQL server instance's msdb as long as it's the same version and build. Alternatively you can just create a new SQL instance and copy the msdb from it.

I'd try following this Microsoft TechNet article on how to recreate the SBSMONITORING database first:


Select as Best AnswerUndo Best Answer


I am very glad and grateful that you gave me advice, but unfortunately problem I have left. can anything else be done?

Select as Best AnswerUndo Best Answer


Download the following package and extract it to c:\windows\temp


Open PowerShell as an administrator, then run the following script:


After the script completes, verify that the monitoring service is running.

If for any reason the above doesn't work, as I previously suggested you can create a new SQL instance, copy the msdb from it then remove the new instance.

If neither of the above works, you may have more problems than just a missing msdb.

Select as Best AnswerUndo Best Answer