How to Move Master Database to a New Location in SQL Cluster

Sep 11, 2012 / By Hemantgiri Goswami

Tags: , ,

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

Share this article

3 Responses to “How to Move Master Database to a New Location in SQL Cluster”

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>