I am very new to SQL cluster. I am upgrading SQL 7.0 Cluster ruining on win2k Adv server. Is it possible to Ghost the image of the cluster nodes and restore if cluster upgrade fails.
May take help fromhttp://support.microsoft.com/support/sql/content/70papers/70clstr.asp this link. _________ Satya SKJ Moderator SQL-Server-Performance.Com
Thanks Twan and staya for the help. This is my current Configuration. SQL Cluster Active/Passive Node A Local drive partitioned into two C: Local Drive: Program files D: Local Drive: Data files Shared Disk Array partitioned into three Q: Quorum Drive: Quorum resource Y: SQL: MS SQL database files Z: Warehouse: backup and archives Node B Local drive partitioned into two C: Local Drive: Program file + MS SQL files D: Local Drive: Data file Not accessible because Node A is Active Q: Quorum Drive: Y: SQL: Z: Warehouse: If I image drive C, D, Q, Y, Z on Node A and drive C, D on Node B. Do I get my cluster back when I restore these images back to its original drives if my cluster upgrade fails? Is there any thing I should worry about while imaging and restoring the image back? Thanks Dipendra
Hi ya,<br /><br />Imaging each of the drives, should allow you to get the cluster back. The image is a low-level copy, so retoring the image would result in the cluster being back to the state it was in when the image was taken.<br /><br />Having said that, I'd still make sure that I had decent normal backups of data files, etc. <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />Cheers<br />Twan
Also for information followhttp://www.sql-server-performance.com/upgrade_7_to_2000_sql_server_cluster.asp Brad's suggestion on Clusters. _________ Satya SKJ Moderator SQL-Server-Performance.Com