SQL Server Clustering

bertieb

I'm not wishing to step on RobertKaucher's toes and his excellent post about building a test lab for practising SQL server clustering from the ground up, however I'd like to share my resources (read 'experiences') regarding the SQL Server installation itself.

I've included some for SQL 2000 more for support purposes (there are an awful lot of SQL 2000 installations out there, many are clustered and a lot are poorly implemented) but I have spared you the horror of NT4/SQL7 clustering - if you're still running one of these you must really like pain, or late nights and overtime

I've built lots of these over the past 10 years, so I hope this post helps someone to create a rock solid SQL server cluster and to spare them from some of the troubles I had. Enjoy!

Failover Clustering on SQL Server 2000
An Introduction to SQL Server Clustering
SQL Server 2000 Failover Clustering
How to Install SQL Server 2000 Clustering
Frequently asked questions - SQL Server 2000 - failover clustering

Failover Clustering SQL Server 2005
Failover Clustering
How to: Create a New SQL Server 2005 Failover Cluster (Setup)
Download details: SQL Server 2005 Failover Clustering White Paper
How to Cluster SQL Server 2005
SQL Server 2005 Clustering Best Practices
http://www.dell.com/downloads/global/solutions/public/white_papers/sql2005_clustering_wp.pdf
How to: Change the IP Address of a SQL Server 2005 Failover Cluster
How to: Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup)
How to: Recover from Failover Cluster Failure in Scenario 1
How to: Recover from Failover Cluster Failure in Scenario 2
How to: Install Microsoft Distributed Transaction Coordinator
Failover Cluster Troubleshooting

SQL Server 2005 and Windows HPC Server 2008
Step 4: Install SQL Server 2005 Standard Edition with Failover Clustering

Failover Clustering SQL Server 2008
Getting Started with SQL Server 2008 Failover Clustering
Optimizing Failover Cluster Performance
How to: Create a New SQL Server Failover Cluster (Setup)
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 1
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 2
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 3
Installing SQL Server 2008 on a Windows Server 2008 Cluster Part 4
Remove a Node From a SQL Server 2008 Cluster
How to: Add or Remove Nodes in a SQL Server Failover Cluster (Setup)
How to: Recover from Failover Cluster Failure in Scenario 1
How to: Recover from Failover Cluster Failure in Scenario 2
Failover Cluster Troubleshooting
How to: Add Dependencies to a SQL Server Resource

astorrs

bertieb wrote: »

...but I have spared you the horror of NT4/SQL7 clustering - if you're still running one of these you must really like pain, or late nights and overtime

Good god I can't imagine having to deal with NT4 Wolfpack these days. Kill me now.

bertieb

astorrs wrote: »

Good god I can't imagine having to deal with NT4 Wolfpack these days. Kill me now.

Bah. It was all 'good character building stuff'. Would you have got to where you are today without those experiences? It was all good for me I'm sure. minus the nervous twitches, voices in my head and the strange aversion to sunlight I have developed due to all the work at night

astorrs

bertieb wrote: »

Bah. It was all 'good character building stuff'. Would you have got to where you are today without those experiences? It was all good for me I'm sure. minus the nervous twitches, voices in my head and the strange aversion to sunlight I have developed due to all the work at night

Took me till Win2k3 before the Wolfpack voices stopped speaking to me and Microsoft finally released cluster software that was comparable with the stuff DEC was selling back in the mid-90's (VAXclusters).

RobertKaucher

I have added a link in my original post in my thread to this thread as well.

RobertKaucher

YouTube - Cluster SQL 2005 in Windows 2008 R2 RC

Just thought I would add the above to the mix...