SQL Server Clustering

Preparing for SQL Server 2000 Clustering

The purpose of this section is to show you how to install SQL Server 2000 clustering onto a Windows 2000 two-node cluster. It already assumes that the cluster server hardware has been installed and configured correctly, and it assumes that Windows 2000 Clustering Services have also been installed and configured correctly.This document provides an example […]

How to Install SQL Server 2000 Clustering

SQL Server 2000 clustering can add much needed reliability and fault-tolerance to a production SQL Server 2000 system. But as you might imagine, its installation and configuration is not as easy an installing SQL Server 2000 on a single server. The purpose of this article is to show you how to install SQL Server 2000 […]

An Introduction to SQL Server Clustering

If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?Being a SQL Server DBA […]

How to Perform SQL Server Log Shipping

The Need for Standby Servers In a perfect world we wouldn’t need standby servers for our SQL Servers. Our hardware would never fail, NT Server 4.0 or Windows 2000 would never blue screen, SQL Server would never stop running, and our applications would never balk. In a partially perfect work, we could afford very expensive […]

Windows 2000 Cluster Services: Testing and Verifying the Windows 2000 Cluster Service

The worst is now over. If you have successfully gotten this far, most likely the Windows 2000 Cluster Service is ready to be used. But since I trust a computer installation only as far as I can throw it (which is not very far), it is a good idea to test the Cluster Service installation […]

Install Windows 2000 Cluster Services: Installing the Windows 2000 Cluster Service: Node 1

This portion of the article shows you, step-by-step, how to install the Windows 2000 Cluster Service. Not every potential option will be discussed, only the most common. This section has been divided into two web pages to make it easier to load into your web browser and read. There are many graphics, and it make […]

Install Windows 2000 Clustering Services: Establishing User Accounts and Security

Setting up the appropriate user accounts and establishing the necessary security is one of the easiest steps when creating a cluster. It is also one of the easiest to forget. What I like to do in this step is not only set up the domain service account for the cluster service, but also to set […]

Install Windows 2000 Cluster Services: Installing and Configuring Windows 2000

Once the hardware is properly selected and assembled, the next step is to install Windows 2000. For the most part, installing Windows 2000 on servers that will be clustered is the same as any Windows 2000 installation. The focus of this section of the the article focus on what is slightly different between installing Windows […]

Install Windows 2000 Cluster Services: Selecting and Preparing the Hardware

Selecting the correct hardware, and preparing it correctly, is half the battle when clustering Windows 2000. As a rule of thumb, if you have done a good job with the hardware, you should not have any difficulty installing Windows 2000 Cluster Services. In fact, it should be a non-event. But if you don’t have the […]

How to Install Windows 2000 Cluster Services

SQL Server clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL Server 7.0 or SQL Server 2000, and time. Lots of it. The purpose of this article is to get you started along your way to SQL Server clustering. As a precursor to this step, you must first install […]