SQL Server > SQL Server Forums > SQL Server Disaster Recovery and Availability > Migrate SAN Disk - Windows 2008 Failover Cluster
Ask a questionAsk a question
 

AnswerMigrate SAN Disk - Windows 2008 Failover Cluster

  • Wednesday, September 30, 2009 11:20 AMy2kBug_sp7 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    • I have a 2 node Windows 2008 64 bit cluster configured...being used a SQL 2008 cluster

      I have a need to migrate the existing allocated SAN disk to a new SAN. 

      Can you point me in the right direction on how to do this?

Answers

  • Wednesday, September 30, 2009 11:30 AMEwan Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi y2kbug

    Ideally the SAN software should do this for you.

    If it doesn't, you need to:

    Take the SQL resources offline,
    present the new LUN to the cluster.
    Copy the files from the old drive to the new
    Swap the drive letters so the new LUN looks like the old LUN
    Take the old LUN resource offline
    Bring the SQL resource back online.

    You'll need your Windows Admins to manage the renaming of the cluster disks, as it can be tricky if you don't have something like SANCopy to do it for you.

    HTH

    Ewan


    If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

    If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
    • Marked As Answer byy2kBug_sp7 Wednesday, September 30, 2009 11:51 AM
    •  

All Replies

  • Wednesday, September 30, 2009 11:30 AMEwan Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi y2kbug

    Ideally the SAN software should do this for you.

    If it doesn't, you need to:

    Take the SQL resources offline,
    present the new LUN to the cluster.
    Copy the files from the old drive to the new
    Swap the drive letters so the new LUN looks like the old LUN
    Take the old LUN resource offline
    Bring the SQL resource back online.

    You'll need your Windows Admins to manage the renaming of the cluster disks, as it can be tricky if you don't have something like SANCopy to do it for you.

    HTH

    Ewan


    If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

    If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
    • Marked As Answer byy2kBug_sp7 Wednesday, September 30, 2009 11:51 AM
    •  
  • Wednesday, September 30, 2009 11:50 AMy2kBug_sp7 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    Ewan,

    Thank you for the quick reply.  Those steps look similar to what I was thinking..  I was wondering, however, how to migrate the Witness disk?  Is this the proper procedure?  http://social.technet.microsoft.com/Forums/en-US/winserverClustering/thread/21002411-a8c9-47c3-ba69-c4f029802473/

     

  • Wednesday, September 30, 2009 2:04 PMEwan Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi

    I don't have any experience of moving the witness disk, but the source of this answer does seem to be impeccable, so I would go along with it!

    Ewan

    If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

    If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.