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