How to Set up Clustering in SQL server 2005

Question

Post reply

How to Set up Clustering in SQL server 2005

dakshinamurthy-655138

SSCertifiable

Points: 5172
More actions
January 7, 2009 at 11:14 pm

#129946

Hi,
I havent tried clustering concept in SQL Server 2005 before, so will you please guide me how to setup the clustering in sql server 2005 step by step. Please provide me a link where in i will get the prerequisites and the step by step to configure.
with regards
Dakshina Murthy

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Books online has a pretty detailed step-by-step instruction about how to install SQL Server on a cluster.

Start here http://msdn.microsoft.com/en-us/library/ms179410(SQL.90).aspx

[font="Verdana"]Markus Bohse[/font]

465789psw Hall of Fame Points: 3314 More actions · Answer 2

also try http://www.jumpstarttv.com/clustering-sql-server-2005_33.aspx, brian knight has 3 good videos there that will give you a good overview.

good luck

DBADave SSChampion Points: 10962 More actions · Answer 3

Here are some good links. For the Microsoft links you can click on the second one and then following the window that opens to your left for additional steps. I created a binder containing many of these documents and highlighted steps specific to our installations. Take the time to document things for your first cluster and the documentation will become very useful for future upgrades until you have done enough where you can do it with your eyes closed. Even then you want to keep the documentation in the event you are hit by a bus and someone else, less familiar with clustering, needs to take over.

-- Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services

http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en

-- Failover Clustering

http://msdn.microsoft.com/en-us/library/ms189134(SQL.90).aspx

-- Before Installing Failover Clustering

http://msdn.microsoft.com/en-us/library/ms189910.aspx

-- How to: Create a New SQL Server Failover Cluster (Setup)

http://msdn.microsoft.com/en-us/library/ms179530.aspx

-- How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster

http://support.microsoft.com/kb/301600

-- Configuring Integration Services in a Clustered Environment

http://msdn.microsoft.com/en-us/library/ms345193.aspx