Joshua Perry (3/21/2008)

---

That has nothing to do with what appears to be a new question:

If you are moving system databases (master, msdb, model, tempdb), you would change the location of master by changing the startup parameters, bringing down the instance, and moving the master.mdf and master.ldf files.

In SQL Server 2005, how would you move the location of the msdb database?

You use the following procedure to move the location of the msdb database:

http://technet.microsoft.com/en-us/library/ms345408.aspx

Joshua Perry (3/21/2008)

---

Also, setting trace flag 3608 at startup and running in single user mode are the same thing, so two of the answers are identical.

The question of the day has changed.

Also, did not know that mssqlsystemresource could be in different location as master.. thanks for the tip. I may have to try this out when I get some time.

Steve Jones - Editor (3/21/2008)

---

I'll reword and change it around.

--http://msdn2.microsoft.com/en-us/library/ms345408.aspx

-- STEP 1 Run and STOP SQL Server
-- model
ALTER DATABASE model MODIFY FILE ( NAME = modeldev, FILENAME = 'X:\SQLDATA\model.mdf')
ALTER DATABASE model MODIFY FILE ( NAME = modellog, FILENAME = 'Y:\SQLLOGS\modellog.ldf')

-- msdb
ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBData, FILENAME = 'X:\SQLDATA\msdbdata.mdf')
ALTER DATABASE msdb MODIFY FILE ( NAME = MSDBLog, FILENAME = 'Y:\SQLLOGS\msdblog.ldf')

--tempdb
--USE master
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'X:\SQLDATA\tempdb.mdf')
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'Y:\SQLLOGS\templog.ldf')

-- STEP 2 COPY physical files

-- STEP 3 Start SQL Server