Friday, February 8, 2013

Moving MSDB Database in MSSQL2000

Moving the Tempdb and Master Database in SQL Server — DatabaseJournal.com:


Moving MSDB Database

In order to move the MSDB and Model database, follow these steps. First, right-click the SQL-Server name and click properties. From the General tab, choose your startup parameters. Next, enter the parameter -T3608. Click OK, stop and restart SQL Server. After the restart, detach the database and move them to their appropriate place.

No comments: