SQL Server Cluster move RRS feed

  • Question



    We are in process of moving the datacenter from Houston to Dallas. Here is the layout


    - Windows 2003, SQL Server 2005 in Active/ active configuration - Production in Houston

    edcddp60 - windows virtual custer name

    edcddp61 and edcddp62 are physical nodes

    edcddp65 - sql server virtual name

    edcddp66\edcddp66 - Named instance of SQL server

    - Windows 2003, SQL Server 2005 in Active/Active Configuration - Staging in Dallas

    staging is in same configuration except the naming convention uses dds rather than ddp.


    We are planning to move the production to Dallas and move the Satging to Houston. We can have Staging down for 48 hours but Production needs to be up and running in 3 hours.


    This is the first time i am involved in cluster move. please provide your ideas on how to do this.


    Thank you very much.



    Tuesday, October 30, 2007 5:44 PM