Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

'SQL Server Citation is a SQL Server blog by Hemantgiri S. Goswami, Surat,India. He is a SQL Server Specialist and SQL Server MVP,Author, President and Leader of Surat User Group
Browse by Tags · View All
Sql server 2008 14
sql 2005 10
sql 2008 10
sql server administration 10
sql server 2005 10
sql 2012 9
sql 2008 r2 9
sql server 2012 8
sql 2012 r2 6
sql 2000 6

Archive · View All
September 2011 9
March 2012 5
December 2011 4
January 2012 4
November 2011 3
April 2013 2
March 2013 2
October 2012 2
October 2011 2
December 2012 1

SQL Server Citation

SQL Server # Moving MASTER database in cluster environment

Dec 24 2012 12:00AM by Hemantgiri S. Goswami   

Few months back I have wrote post about moving MASTER and MSDB database to new location in stand alone machine.

In recent past we had a situation where customer asked us to move MASTER database to new location, below are the steps I have taken:

  1.     Connect to the Server
  2.     Open Configuration Manager -> SQL Server Service
  3.     Right Click and say Properties
  4.     Click on the Start-up Parameter
  5.     Remove start-up parameter (the highlighted one)
	 -dOLDLocation\master.mdf
-eOLDLocation\ErrorLog
-lOLDLocation\mastlog.ldf



 



      6.     Add new start-up parameters with new values (per your configuration)

   




	 -dNewLocation\master.mdf
-eNewLocation\ErrorLog
-lNewLocation\mastlog.ldf



      7.    Check and confirm which node is active

      8.    PAUSE current PASSIVE Node  to avoid fail-over


      9.    Take SQL Server resources offline, i.e. SQL Server, SQL Agent, MSDTC, SQLCLUSTER Name (do not take SQL Cluster IP Offline)


    10.    Copy MASTER.MDF and MASTLOG.LDF to NEW Location ( S:\SQLDATA, yours could be different)


    11.    Log into Cluster Administrator and bring SQL Server Resources online


    12.    Resume current PASSIVE Node



 



That's all, you should be able to see your master database on new location now!!!



 



-- Regards,



Hemantgiri S. Goswami (http://www.sql-server-citation.com )



Cross posting: http://www.pythian.com/news/35829/moving-master-database-to-new-location-in-sql-cluster/


Republished from SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP [15 clicks].  Read the original version here [1 clicks].

Hemantgiri S. Goswami
110 · 1% · 467
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server # Moving MASTER database in cluster environment" rated 5 out of 5 by 1 readers
SQL Server # Moving MASTER database in cluster environment , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]