Skip to content

Insight and analysis of technology and business strategy

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

    1. Connect to the server
    2. Open Configuration Manager -> SQL Server Service
    3. Right click and select Properties
    4. Click on the Startup Parameter
    5. Remove startup parameter (the highlighted one)
         -eG:\Program Files\Microsoft SQL Server\MSSQL\Log\ErrorLog
  1. Add new startup parameters with new values (per your configuration)
  2. Check and confirm which node is active
  3. PAUSE current PASSIVE node  to avoid fail-over
  4. Take SQL Server resources offline, i.e. SQL Server, SQL Agent, MSDTC, SQLCLUSTER Name (Do not take SQL Cluster IP Offline.)
  5. Copy MASTER.MDF and MASTLOG.LDF to NEW Location ( S:\SQLDATA, but yours could be different)
  6. Log into Cluster Administrator and bring SQL Server Resources online
  7. Resume current PASSIVE Node
-eG:\Program Files\Microsoft SQL Server\MSSQL\Log\ErrorLog

Top Categories

  • There are no suggestions because the search field is empty.

Tell us how we can help!