SQL 2005 Clustering

[adfreek]

Hello,

I've set up a few two node active/passive SQL 2000 clusters in the past but now a client is asking for a two node SQL 2005 active/passive cluster. I'm assuming this is still possible in 2005 but just can't seem to find any good resources related to SQL 2005 clustering. Can anyone provide any?

What version of SQL 2005 must we be running? Etc..

Many thanks,

 

[MDXer]

yes it is possible sorry I don't know of any documentation.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Catadmin]

There really isn't a whole lot of SQL 2k5 documentation out yet. I went looking in a bookstore for it last week. Nada.

I take it MS's website or Books Online doesn't have anything?



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.

 

[mrdenny]

Setting up a SQL 2005 cluster is just as easy as setting up a SQL 2000 cluster.

Here's a basic walk through.

First setup the Windows 2003 servers in a cluster.
Now create another cluster group (I like to name it the same as my virtual world) and add in the drives that you'll be using for the SQL Server.

Bring the new group online.

Launch the installer on one of the nodes.

When it asks you what services to install click SQL Server then click the Cluster check box under in. About half way through the install screens it'll ask you what cluster group to install to and what drive to use for the data files, and what the virtual name and IP will be.

If you have questions let me know, we've setup 2 SQL 2005 clusters already and have 2 or 3 more to setup.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

If you are going to have a 2 node cluster you can use Standard edition. Enterprise Edition is only needed for a 3+ note cluster (or if you need more than 4 CPUs or the extra features that come with Enterprise).

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[adfreek]

Thanks Denny! We'll be attempting our cluster build and SQL install this week.