Clustering

Question

Post reply

Clustering

Heather-826940

SSC Eights!

Points: 817
More actions
July 23, 2008 at 10:36 am

#70474

I have inherited a Clustered SQL Server 2000 environment. I know nothing about SQL Server clustering. What can I do, or T-SQL code can I run to determine how clustering of my SQL Server 2000 machine is configured? Also what resources would be good to get up to speed quick on how to manage my clustered server. Also I've been told that we need to set up a clustered SQL Server 2005 machine that will be used to migrate all the 2000 databases. Any idea how I might consider setting up a SQL Server 2005 clustered environment to mirror what was done in SQL Server 2000, and improve on it if we can.

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

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

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 1

1. Cluster administration in OS

2. Run sp_configure in QA

3. Server Properties in EM

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

If you need to do something like migrate, hire a consultant. You're asking for trouble on your own.

If you want to know how it's configured, that's not an easy thing to answer. There are lots of things to configure. I'd read the whitepapers on clustering for Ss2K, learn what there is to set and worry about, and then examine your server.

Clustering is basically on the Windows level with SQL sitting above that and using resources from Windows. It presents a virtual SQL instance to users.