Moving the master database
|
1. |
Change the path for the master data files and the master log files in SQL Server Enterprise Manager.
Note You may also change the location of the error log here. |
|
2. |
Right-click the SQL Server in Enterprise Manager and then click Properties. |
|
3. |
Click Startup Parameters to see the following 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:
-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. |
Note If you are using SQL Server 2005, use SQL Server Configuration Manager to change the path for the master data files and the master log files.