The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Tuesday, December 18, 2018

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book

 

Halloween 2006_09.Jpg

  bob Links
Customize Links
Ale--not beer--in a pewter mug was comme it faut, the only thing for a gentleman of letters, worthy of the name to drink. - Guy De Maupassant, "Twelve Men"
Wider View Insert

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
     User Management
     System Databases
          Crib Sheet - SQL Ser...
          Moving the MSDB Data...
          Moving the Model Dat...
          Moving the master da...
     BCV
     Deadlocks
     Temp Tables
Windows OS

Insert Category

Will be added as a sub-category of, System Databases
Moving the MSDB Database

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