Moving MASTER database to New Location in SQL Cluster
Sep 11, 2012 / By Hemantgiri Goswami
Recently we had a situation where in customer have asked us to move Master Database from Local Drive to SAN drive, I have outlined to steps for the task:
Moving Master in SQL Server Cluster
————————————————————————————————————————————————-
- Connect to the Server
- Open Configuration Manager -> SQL Server Service
- Right Click and say Properties
- Click on the Startup Parameter
- Remove startup parameter (the highlighted one)
-dS:\SqlData\master.mdf
-eG:\Program Files\Microsoft SQL Server\MSSQL\Log\ErrorLog
-lS:\SqlData\mastlog.ldf
- Add new startup parameters with new values (per your configuration)
- Check and confirm which node is active
- PAUSE current PASSIVE NodeĀ to avoid fail-over
- Take SQL Server resources offline, i.e. SQL Server, SQL Agent, MSDTC, SQLCLUSTER Name (do not take SQL Cluster IP Offline)
- Copy MASTER.MDF and MASTLOG.LDF to NEW Location ( S:\SQLDATA, yours could be different)
- Log into Cluster Administrator and bring SQL Server Resources online
- Resume current PASSIVE Node
-dS:\SqlData\master.mdf -eG:\Program Files\Microsoft SQL Server\MSSQL\Log\ErrorLog -lS:\SqlData\mastlog.ldf
3 comments on “Moving MASTER database to New Location in SQL Cluster”
Leave a Reply
You must be logged in to post a comment.

Pingback: SQL Server # Moving MASTER database in cluster environment ~ SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
So, no changes to the passive side of the cluster? the changes are all carried over to the passive node?
Yes, it will carried over as SQL Server would be a shared across both nodes.
Thanks
Hemantgiri