Deletion of system DB

• premkuttan

  SSCommitted

  Points: 1934

  More actions

  April 27, 2011 at 7:28 am

  #238478

  In one of the server the sql service is stopped and msdb db is deleted

  Kindly let me know in what way i can bring the service up. I have backup of the MSDB DB. I cudn't start my service now

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  April 27, 2011 at 8:06 am

  #1316605

  SQL server will still start without msdb, its just SQLAgent will not start up.

  so you should just be able to restore msdb in the normal way.

  change the owner of msdb to sa afterwards then start SQLAgent

  ---------------------------------------------------------------------