SQL Server Clustering

Managing and Connecting to AlwaysOn Availability Groups

From the previous AlwaysOn Availability Group article, we provided a name for the availability group listener which is simply a unique DNS name as a Virtual Network Name (VNN) to direct read-write requests to the primary replica and read-only requests to the read-only secondary replica. In this way the client doesn’t need to know which […]

Configuring and Creating An AlwaysOn Availability Group in SQL Server 2012

In the previous article on AlwaysOn Availability Groups in SQL Server 2012, we looked at The Environmental Setup for An AlwaysOn Availability Group. In this article we turn our attention to the creation and configuration of the Availability Group. There are two primary steps to creating an AlwaysOn availability group which has to be done […]

Inside SQL Server Cluster Setup and Troubleshooting Techniques – Part I

The SQL Server Setup process is really straight-forward. An experienced user who has got a little knowledge in setting up other applications can also perform a SQL Cluster Setup but what if issues occur? What will you do if you don’t see the newly added disks in the SQL Cluster Setup wizard? What will you […]

Database Mirroring in SQL Server 2005

SQL Server 2005 provides a set of high availability methods that the users can use to achieve fault tolerance and to prevent server outages and data loss. The selection of the high availability method depends on various factors. Some DBAs need the servers to be available 24/7, while others can afford an outage of a […]

SQL Server 2005 Clustering Best Practices

In this section, I summarize all of the best practices you should follow if you want to install, configure, and maintain a solid SQL Server 2005 cluster. Think of this as a cluster checklist to success. Before You Begin Planning Planning in detail is essential! You should spend more time planning than you do in […]

How to Cluster SQL Server 2005

Believe it or not, the procedure to install a SQL Server 2005 instance onto a cluster is one of the easiest parts of getting your SQL Server 2005 cluster up and running. The SQL Server 2005 setup program is used for the install and does the hard work for you. All you have to do […]

SQL Server 7.0, 2000 and 2005 Clustering Resources

As important as SQL Server clustering is to those companies that implement it, trying to find good information on how to implement and administer it is another story. And this is why I put this article together. If you are seriously considering implementing SQL Server 2000 or 2005 under Windows 2000 or Windows 2003; then […]

How to Cluster Windows Server 2003

Before you can install SQL Server 2005 clustering, you must first install Windows Server 2003 clustering services. Once it is successfully installed and tested, then you can install SQL Server 2005 clustering. In this article, we take a step-by-step approach to installing and configuring Windows 2003 clustering. In a later article, we will learn how […]

An Introduction to SQL Server 2005 Clustering Basics

Clustering is a complex technology with lots of messy details. To make it easier to understand, let’s take a look at the big picture of how clustering works. In this article we take a look at: Active vs. Passive Nodes Shared Disk Array The Quorum Public and Private Networks The Virtual Server How a Failover […]

Preparing the SQL Server 2005 Clustering Infrastructure

Before you even begin building a SQL Server 2005 cluster, you must ensure that your network infrastructure is in place. Here’s a checklist of everything that is required before you begin installing a SQL Server 2005 cluster. In many cases, these items are the responsibility of others on your IT staff. But it is your […]