How to Move Master Database to a New Location in SQL Cluster
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
Share this
Previous story
← Flashback and Forth
You May Also Like
These Related Stories
Oracle 12.2 ASM filter driver installation
Oracle 12.2 ASM filter driver installation
Dec 29, 2017
8
min read
MSDTC and configuration details for cluster/Always On
MSDTC and configuration details for cluster/Always On
Oct 24, 2022
8
min read
Stabilize Oracle 10G's Bind Peeking Behaviour
Stabilize Oracle 10G's Bind Peeking Behaviour
Mar 18, 2008
10
min read
No Comments Yet
Let us know what you think