about change storages of the SQL server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

about change storages of the SQL server

I come from Taiwan, and my name is Caney. I am writing because I have a question about the SQL 2000 cluster. Our customer has two servers that are running windows 2003 server enterprise and SQL 2000 enterprise. They also configured windows 2003 server clusters and SQL 2000 clusters, and now it¡¦s working smoothly. Recently, our customer wants to transfer their database from EMC AX-100(fiber channel storage) to IBM SHARK. Because of this reason, the new drive letters (IBM shark-> x and y) have to replace original drive letters (EMC AX-100-> q and r). Presently, two servers direct connect with two fiber storage, and I can see four shared drives on both servers. Now I must to finish this job but I can¡¦t confirm that the steps are right. 1. uninstall SQL virtual name, virtual IP . 2. uninstall SQL server both servers. 3. uninstall windows cluster. 4. install windows cluster and use drive letter x as quorum drive. 5. install SQL cluster and uses drive letter y as shared drive. Are these steps right ? Would you give me any suggestion ? thanks.
I think, you need to uninstall SQL Server first
1. uninstall SQL server both servers. ( This will uninstall SQL Server from both nodes and remove SQL Virtual name and IP, no need to explicitly uninstall them, Do not try to uninstall VirtualName and IP first, this may cause to damage the setup of SQL Cluster and you won’t able to uninstall the SQL Server properly)
2. uninstall windows cluster Services
3. Configure/rename the Drives
4. install windows cluster and use drive letter x as quorum drive.
5. install SQL cluster and uses drive letter y as shared drive. I think this will work. -Johnson
]]>