SQL 2000 Active/Passive Cluster migration to new site

Posted on 2012-08-21
Last Modified: 2013-01-07
We currently have an Active/Passive MS SQL 2000 cluster on Windows 2K3 Enterprise, with the back-end storage being HP 24K.  We are moving data centers and are trying to minimize the amount of outage time, does SQL 2000 support stretch clustering or are there any other suggestions that could reduce the amount of downtime during a data center relocation?
Question by:gninos
    LVL 44

    Expert Comment

    by:Vitor Montalvão
    What you mean with stretch clustering? A cluster with one single node? If so, the answer is yes.

    Author Comment

    Stretch clustering meaning having spilting the cluster nodes up between two different data centers.
    LVL 28

    Accepted Solution

    I've not heard the term "Stretch clustering" before, but I believe what you're suggesting is called "Geo-clustering", meaning that the nodes are geographically dispersed. While Microsoft doesn't support this in certain configurations, the reason for this lack of support is just that the heartbeat network is very sensitive to latency and hiccups, and long-distance networks tend to have more than a tolerable amount of both. How far away is your new data center? What's the latency? If it's under 10ms (not sure what kind of connection you have between your two data centers), then geo-clustering may still be an option - move one node to the new data center, fail to it, then move your other node. As you don't need the cluster to run across both data centers for longer than it takes to fail over and do some testing, you might be okay here.

    I'm not sure if you've seen this article, but it appears targeted for SQL 2000 - specifically, section 4 is called "Deploying Stretch Clustering" (though it cryptically refers to "stretch clustering" as a "high-availability solution offered by third-party vendors" but doesn't give any indication who those vendors are. In any case:

    In this situation, I'd consider setting up replication to the new data center and then failing the applications over to the new site. With SQL 2000, your options are limited since the HA technologies are a decade old, but you may still have some options.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now