Hello everyone!

We currently have a one node cluster (w2k3 and sql2000ent) and have had it
this way for a while waiting on the second server to arrive, well, the time
has come and now we are about to install the second node in this
active/passive cluster.

I have been reading in booksonline on how to do this and it seems fairly
simple. Install the second server, add it to the cluster and run sql setup
on it, choosing "maintaining a virtual server for failover" and so on. Am I
right so far?

My questions are:
Should I run the sql installation from the new node or from the old one? Or
does it not matter?
When the installation is done I've understood that I have to reapply sp3a?
And that this is done from the node that is currently the owner?

Thanks in advance for your help!
Regards,
Erik

1. You run SQL Server setup from the old node, with SQL Server running on
that node.

2. You run SP3a from the node that currently owns SQL Server while SQL
Server is active on that node.

You will also need to apply any patches as well.

Rand
This posting is provided "as is" with no warranties and confers no rights.

1. You run SQL Server setup from the old node, with SQL Server running on
that node.

2. You run SP3a from the node that currently owns SQL Server while SQL
Server is active on that node.

You will also need to apply any patches as well.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Thanks alot for those tips!
/Erik

"Rand Boyd [MSFT]" <rboyd (AT) onlinemicrosoft (DOT) com> wrote