Moving the MSDB database
SQL Server 2005 and SQL Server 2000
To move the MSDB database, you must startt SQL Server together with the -c option, the -m option, and trace flag 3608. Trace flag 3608 prevents SQL Server from recovering any database except the master database. To add the -c option, the -m option, and trace flag 3608, follow the steps in the "Moving the model database" section. After you add the -c option, the -m option and trace flag 3608, follow these steps:
|
1. |
Stop, and then restart SQL Server.
|
|
2. |
Make sure that the SQL Server Agent service is not currently running.
|
|
3. |
Detach the msdb database as follows:
use master go sp_detach_db 'msdb' go |
|
|
|
|
4. |
Move the Msdbdata.mdf and Msdblog.ldf files from the current location (D:\Mssql8\Data) to the new location (E:\Mssql8\Data).
|
|
5. |
Remove -c -m -T3608 from the startup parameters box in Enterprise Manager.
|
|
6. |
Stop and
|
|
|