Recently, we had a situation where a customer asked us to move Master Database from Local Drive to SAN drive. I have outlined the steps for the task:
Moving Master in SQL Server Cluster
————————————————————————————————————————————————-
- Connect to the server
- Open Configuration Manager -> SQL Server Service
- Right click and select 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, but 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
4 Comments. Leave new
[…] now!!! – Regards,Hemantgiri S. Goswami (https://www.sql-server-citation.com )Cross posting: https://www.pythian.com/news/35829/moving-master-database-to-new-location-in-sql-cluster/ var linkwithin_site_id = […]
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
Hi,
I have a two node sqlcluster 2008R2 on server2012, and security update for sqlserver failed because the system database’s where placed in the cluster disk (D:\).
I am thinking of two ways to get this fixed:
1. Move the system databases to local C:\ on both nodes so i can install the patches without downtime.
2. Use a mount point and shared it b/w both the nodes and place the systems database there, that way the path will remain the same.
Please advice.
Regards,
Mrudul