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)
         -dS:\SqlData\master.mdf
         -eG:\Program Files\Microsoft SQL Server\MSSQL\Log\ErrorLog
         -lS:\SqlData\mastlog.ldf
  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
-dS:\SqlData\master.mdf
-eG:\Program Files\Microsoft SQL Server\MSSQL\Log\ErrorLog
-lS:\SqlData\mastlog.ldf

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=""> <strike> <strong>