Clustering two MS SQL 2000 serveres

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:

> 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.
>
|||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@.epprecht.net> wrote in message
news:D6160553-ADDF-41DF-A3CE-F59DEF47E7B0@.microsoft.com...[vbcol=seagreen]
> 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: