[Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL 2000 Active/Passive Cluster migration to new site

Posted on 2012-08-21
Medium Priority
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 53

Expert Comment

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

Author Comment

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

Accepted Solution

Ryan McCauley earned 2000 total points
ID: 38322543
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.

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

868 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