This is done in the startup parameters of your SQL
Server. You'll just have to specify the parameter to move
it to a different drive.

Thanks,
Steven S. Warren
MCDBA,MCSE,MCSA,CCA

Step-by-step instructions to move the Master Database
----------------------------------------------------------------------------
--------

1. Change the path for the master data and log files in SQL Server
Enterprise Manager. NOTE: You may optionally change the location of the
error log here as well.

2. Right-click the SQL Server in Enterprise Manager and click Properties.

3. Click the Startup Parameters button and you will see similar entries:


-dD:\MSSQL7\data\master.mdf
-eD:\MSSQL7\log\ErrorLog
-lD:\MSSQL7\data\mastlog.ldf

-d is the fully qualified path for the master database data file.

-e is the fully qualified path for the error log file.

-l is the fully qualified path for the master database log file.

4. Change these values as follows:

a. Remove the current entries for the Master.mdf and Mastlog.ldf files.

b. Add new entries specifying the new location:
Example :
-dE:\SQLDATA\master.mdf
-lE:\SQLDATA\mastlog.ldf


5. Stop SQL Server.

6. Copy the Master.mdf and Mastlog.ldf files to the new location
(E:\Sqldata).

7. Restart SQL Server.


HTH,

Uttam Parui
SQL Server Developer Support Engineer, MCDBA, MCSE, MCT
Product Support Services
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.