Cluster Image | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cluster Image

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.

yes as long as no changes are made between ghosting the first and subsequent nodes Cheers
Twan
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

]]>