Thursday, September 13, 2007

Rebuilding MSDB on SQL2K

  1. In SQL Server Enterprise Manager, right-click the server name andclick Properties.
  2. On the General tab, click Startup Parameters.
  3. Add a new parameter as "-T3608" (without the quotation marks).
  4. Stop, and then restart SQL Server.
  5. Make sure that the SQL Server Agent service is not currently running.
  6. Detach the msdb database as follows:use master GO sp_detach_db 'msdb' GO
  7. Delete or rename the msdb mdf and ldf files.
  8. Run the INSTMSDB.SQL script
  9. Remove the -T3608 trace flag from the startup parameters box in Enterprise Manager
  10. Stop, and then restart SQL Server.