I want to institute a high availability solution for SQL Server with no downtime. I am planning on using Microsoft clustering, but I have been told that in the event that the cluster moves the SQL Server from one physical server to another, that there is some downtime. Why is this so?  Read more...

This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.  Read more...

A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.  Read more...

This article from shows how to prepare your SQL Server 2005 clustered environment for Service Pack 3 and avoid some common problems.  Read more...

People don't plan to fail; they fail to plan. Single node clustering provides organisations with a ready made scale-up or high availability platform from the beginning of the deployment.  Read more...

Continuing with setting up a 2 node SQL cluster under MS Virtual server 2005 Ent R2 SP1, Perry Whittle looks at the SQL configuration in this article.  Read more...

This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers.  Read more...

Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.  Read more...

Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.  Read more...

Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.  Read more...

Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.  Read more...

How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?   Read more...

If you are in a clustered environment, check out this article from James Greaves. Here we learn how to deal with the clustered disk space and mount points.  Read more...

Windows Server 2008 has a lot of differences from its previous versions and one of them is the clustering feature. How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?  Read more...

Learn how you can monitor the SQL Server instances for failover of a cluster or a restart.  Read more...

I am trying to determine which of the logical volumes on the shared disk are associated with each SQL Server instance. Is there a simple method in T-SQL to determine this without having to fire up Cluster Administrator?  Read more...

Part 1 of this series discussed how to prepare for SQL Server cluster installation on a two-node Windows Server 2003 cluster. This installment explains how to install SQL Server Database Engine on the cluster using the Integrated Installation option.  Read more...

Part 1 of this series discusses the prerequisites for SQL Server cluster installation. Subsequent installments will provide step-by-step examples of SQL Server 2008 cluster installation.  Read more...

This article describes the SQL Cluster Setup process and how to troubleshoot it if something goes wrong  Read more...

Part 4 in this series on upgrading an Active/Active cluster to SQL Server 2005 details how to push live data from one cluster to another using a conversion DB and replication.  Read more...

A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.  Read more...

This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers.  Read more...

If you are in a clustered environment, check out this article from James Greaves. Here we learn how to deal with the clustered disk space and mount points.  Read more...