We have SQL 2005 cluster on two nodes with Windows 2003 server. I want to
replace disk "x" with new one disk "y". Disk "x" shared and is used for
databases and logs and Analysis services and SQL server cluster resoruces
have denepdencies on that disk.

What is the right procedure to do that?

Thank you!

SQL Server only uses drive letters to locate its resources, even on a
cluster (unless you are using mount points, then the game changes
completely).

You can add the disk and present it locally to one node. Then you shut down
the SQL Services and copy everything to the new drive. Add the disk as a
clustered resource and remapo the drive letters. Test this with failover a
couple of times to make sure.

If you are using mount points, then you have to copy the disk signatures
with the cluster service offline but the cluster disk driver operating
manually. Not for the faint-hearted.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"Lehrovsk" <Lehrovsk (AT) discussions (DOT) microsoft.com> wrote

"Lehrovsk" <Lehrovsk (AT) discussions (DOT) microsoft.com> wrote

This might help:
http://msmvps.com/blogs/clusterhelp/...l-22-2005.aspx


--
Russ Kaufmann,
MVP, MCSE: Messaging and Security, MCT, MCITP, MCTS and other stuff

ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp