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?

Thanks.

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

"Roust_m" wrote:

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

"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote