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.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 ... :-)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment