SQL Server Clustering

Designing your SQL Server Cluster

Preparing Cluster Resource Groups As a first step, the DBA should list all server-based applications and services that will run within the cluster environment, regardless of whether they will need high availability. Applications and services that need to be highly available should be placed into resource groups. Other applications should be tracked, and their interactions […]

Installation of SQL Server Clustering

Pre-Installation Spot Verification Review the Windows Event Log, it should not have any errors before you begin the SQL Server clustering installation. Ping from one node to another to verify a good connection and a latency of less than 500ms. In regard to the services listed under Pre-Install Preparation Checklist above, make sure all of […]

Gigabit Ethernet Direct Connect Networking

A useful device in Ethernet networking is the cross-over cable. There are circumstances where it is necessary to network two computers together and nothing else. Examples include test environments and clustered systems. In such cases, it is desired to avoid the need for a dedicated network switch. On Ethernet and Fast Ethernet networks, this is […]

How to Implement SQL Server Log Shipping Using Visual Basic

Log Shipping is a Disaster Recovery (DR) tool that provides you the ability to have a readily available “warm backup.” Essentially, should your existing system fail, you have a backup SQL Server and database available to take over with relatively up-to-date information. If your database is critical to your business, such as in a call center, […]

Achieving Massive Scalability with SQL Server

With each release, Microsoft SQL Server continues to gain in performance and scalability. A little known fact buried under Oracle marketing is that SQL Server’s TPC-C score is now even higher than Oracle’s. However, few other than Microsoft have millions of dollars of hardware needed to generate the 709,220 transactions per minute achieved in the […]

How to Upgrade a SQL Server 7.0 Cluster to a SQL Server 2000 Cluster

Every time I have to perform some major work on my production SQL Server clusters, I spend a lot of time researching and planning the task at hand. And when it comes to something as big as an upgrade from a SQL Server 7.0 Cluster to a SQL Server 2000 cluster, I even spend more […]

Real Life DBA: Dealing with a SQL Server Cluster Failover

Monday 9:30AM I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived […]

Testing SQL Server 2000 Clusters

If you have successfully gotten this far, most likely the SQL Server 2000 cluster is ready to be used. But before I trust any production systems on a new cluster, it is a good idea to test the SQL Server 2000 cluster to see if it is really working as it should. This section takes […]

Installing the SQL Server 2000 Service Pack

Because of the nature of SQL Server 2000 clustering, you want to ensure that it is as reliable as possible. One of the ways to help ensure that is to be sure that you have installed the latest SQL Server 2000 Service Pack on the SQL Server 2000 Cluster before you put it into production. […]

Installing SQL Server 2000 Clustering

If you have ever installed SQL Server 7.0 in a cluster, you will need to forget what you know, as installing SQL Server 2000 into a cluster is quite different, and in fact, it is much easier.The following steps should be run from the node of the cluster that you consider your primary node. This […]