July 12, 2008 at 5:43 am
Hi Everyone,
I need to migrate the data from the old storage to the new Storage HP-SAN.
Moreover, the SQL Server 2005 Instance is Fail-over Clustered.
How to move all the databases if it is fail-over clustered from one Storage to New Storage?
Will it be same as moving databases normally from one storage to another storage or
Would it be anything different?
Please help me..
Regards,
Nag
[font="Arial"]Naga Raju Appani[/font]
July 12, 2008 at 2:34 pm
Hi
It all depends on the storage , are you going to present the new drives from the new storage as another drive letter ,
If so you can disable the fail over and stop the sql server service and do a full copy over to the new storage drives of all sql data , rename the old drives to something else and rename the new drives to the original drive letter , bring up the cluser services , sql services and all will be there up and running , CHeck you databases are fine and run a checkdb and optimization on the DBS
IF you are not going to do the above than a backup and restore will be a solution after the rebuild of the cluster with the new storage
kind regards
W
July 12, 2008 at 2:58 pm
are you using redundant HBA's? It would be advisable
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2008 at 9:35 pm
= You can also use drive-letter swapping to move the databases to a new storage site. Make sure you have backups for all the databases being moved.
= Copy the system database files to the new storage device.
= If the SQL Server environment is a clustered environment, you need to ensure that the folder structure and the drive letter are kept the same.
= Copy user database files to the new storage device.
= Restart the SQL Server, SQL Agent, and MS Search services.
= Attach the user databases.
= Move other folders (e.g., backups, Repldata) to the new storage drive. If the drive letter for the backups and Repldata changes, the associated scheduled SQL Server jobs need to be modified to reflect the change.
= Copy any other folders or files that will be accessed by the jobs (e.g., DTS packages, stored procedures) to the new storage drive.
= Run DBCC CHECKDB to verify database consistency.
Maninder
www.dbanation.com
July 13, 2008 at 1:14 am
Hi Mani,
Thanking u 4 ur post......
In fact, i am very much new vth SQL Server. I have been learning it.
Instead, I am Oracle Certified Profeesional. My client has challenged me to du this job.....
I kneu moving Databases Normally ..but having a konfusion over kluster.....
When must i change the drive letters in the Cluster Admin...vud it b after moving Databases or b4 moving Databases?
If the neu Drive letters named same, isnt it necessary to change the deisgnation in the Cluster admin?
One more klarifikation!...
Can i reinstall the kluster after normally moving the Databases?
Please help me out1
Iz there any documentation doing this?
Will be waiting 4 ur response!
Thanking you,
Regards,
Nag
[font="Arial"]Naga Raju Appani[/font]
July 13, 2008 at 6:46 am
Mani Singh (7/12/2008)
you need to ensure that the folder structure and the drive letter are kept the same.
especially the folder permissions, that applies to SQL whether clustered or not
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply