Replace Cluster Disks

Hello,

I have a two node SQL 2000 cluster running on windows 2003 enterprise server. We need to replace the SAN disks. Can we not disable SQL service & Cluster service, copy the contents from existing disks to target disks, swap the drive letter & start the services?

What is the best practice to do this? Appreciate your help.

Thanks
Rajan

That 'should' work just fine. But STOP the SQL services, including SQL Agent and SQL Browser that depend upon the drive.|||

It was not that straight forward. Cluster does not use drive letters for the volume....it uses the disk signatures.

I had to use clusterrecovery.exe utility from resource kit. It is a great tool.

Regards
Rajan

|||

This technique will work just fine. I've used it many times.

In the cluster administrator stop the SQL Server and the SQL Agent.

Attach the new luns to the servers, and make them cluster resources.

Copy ALL the files and folders from the old drive to the new drive.

Switch out the drive letters so that everything looks eactly like before (just with the new drives).

Update the cluster resources lables for the drives so that they match the correct new drive letters.

Change the dependencies on the SQL Server cluster resource so that it now depends on the correct drive letters.

Startup the SQL Server and SQL Agent services in the cluster administrator.

All should be working well after that.