July 23, 2008 at 12:32 pm
1. Cluster administration in OS
2. Run sp_configure in QA
3. Server Properties in EM
July 23, 2008 at 12:35 pm
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.
July 23, 2008 at 3:50 pm
This is great advice. I don't suppose you have any links to great white papers on the clustering subject?
July 23, 2008 at 4:21 pm
Check these ones:-
How to Install SQL Server 2000 Clustering
http://greatpbs.com/objects/Documents/SQL%20Server%202000%20Clustering.pdf
Read High Availability using Clusters under
http://hosteddocs.ittoolbox.com/CK121704.pdf
Clustering SQL Server 2000 from 500 Feet
http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/
Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000
http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/
Manu
July 24, 2008 at 8:28 am
Excellent articles on SQL 2000.
Any articles on clustering of a SQL Server 2005 machine that you would recommend?
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply