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