Results 1 to 2 of 2

Thread: MSDB suspect

  1. #1
    Join Date
    Aug 2002
    Location
    india
    Posts
    41

    Unanswered: MSDB suspect

    Hi,

    What are the steps I should execute if MSDB database is showing suspect.

    The conditions is we dont have a backup but the sqlserver is running.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Look at the sql server logs and see what might have caused this. Look in bol for sp_resetstatus. Worst case scenario, you will have to detach the msdb and run instmsdb.sql to recreate (however, you will lose all information stored in the msdb - DTS packages, scheduled tasks, backup/restore history, replication).

    Oh yes - One last step - BACKUP ... :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •