Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Moving System Databases in a SQL Cluster Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 12:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 9:04 PM
Points: 46, Visits: 113
Hi,


Iam tasked to move our System Databases (master,model & msdb) to a new storage location onto a different LUN / drive. Its a SQL Server 2008 R2 Active/Passive failover SQL Cluster.

I'm assuming that the process for moving all the 3 databases are same. Is the procedure any different for moving the master database? Please advise.

Aside, I'm planning to proceed it in this order: Model and then MSDB and then move the master. Is that okay?

Other than taking a backup of these 3 System Database files, is there any thing else that I should safe guard so i can revert back the database in the event of a calamity?

As for the Cluster, am I required to do anything, take any resource offline, etc?


Thanks,
Jai
Post #1446314
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse