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

LifeAsBob

  Wednesday, September 19, 2018

 


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

 

July 4th 2007

  bob Links
mssqlserver.com SQL ...
For when the lepers she nursed implored her for beer and there was none to be had, she changed the water which was used for the bath into an excellent beer, by the sheer strength of her blessing, and dealt it out to the thirsty in plenty. - From the Life os St. Brigid
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 master database

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.