SQL Server Performance

Cluster Image

Discussion in 'SQL Server Clustering' started by dneupane, Nov 26, 2003.

  1. dneupane New Member

    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.
  2. Twan New Member

    yes as long as no changes are made between ghosting the first and subsequent nodes

  3. satya Moderator

  4. dneupane New Member

    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?


  5. Twan New Member

    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
  6. satya Moderator

Share This Page