Clustering two MS SQL 2000 serveres -- sql server clustering

roustam NO[at]SPAM hotbox.ru
9/23/2004 4:45:08 AM

Hi!

I need to make an active/active cluster out of two servers. One of
them is critical and has huge number of published tables, so I want it
to be available the sooner the better. What is the best way to do
this?

When moving critical servers I practiced this aproach:

1. Stop sql-server service

2. Copy all databases file on a new server

3. Shut down the old one

4. Name the new the same name and install MS SQL Server 2000 on it

5. Stop the sql-sever service and replace the its databases files with
the ones copied from the old server

6. Start the sql-server service

Since one of the sql server nodes will have to be renamed the way
like: node2\second, the above aproach will not work for the second
server. But will it work for the first? Are there any subtleties
concerned with possibly different way a clustered MS SQL Server works?

Mike Epprecht (SQL MVP)
9/23/2004 5:03:04 AM

Hi

You can not rename a cluster, but you could create a DNS alias for your old
server's name to map to the new cluster's name. Until you change your
applications and scripts.

Regards
Mike

[quoted text, click to view]

Rodney R. Fournier [MVP]
9/23/2004 9:48:03 AM

Not sure if you have seen this Q yet http://support.microsoft.com/?id=307336

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Clustering two MS SQL 2000 serveres