Open the SQL Server configuration manager.

1

We are moving the master database of Default Instance. Right click on the SQL Server service and open properties.

2

Go to “Startup Parameters”.

3

In the startup parameters ‘-dC:\Program Files….’ is the directory of the master database data file. Click on the existing parameter for data file, change the directory and click “Update”.

4

“-lC:\Program….” Is for the directory of transaction log file of master change we have to relocate that too to the new location. Click “Update”.

5

When we “Apply” the changes we get warning stating that changes will be only be applied once we restart the services.

6

Stop SQL Server Service.

7

Move the Master database (both .mdf and .ldf file) from the old location to the new location stated in “Startup Parameters”.

8

8b

Start the SQL Server service.

9

To verify the results run “Select * from sys.master_files”. Check the location of master database.

10

Moving Master Database

Leave a Reply