Well, they have the steps in the BOL. Basically:
1) You add the new node to the cluster with Cluster Admin.
2) Next, you run the SQL Server 2000 install. You're not installing a
new instance; you're using the advanced installation options. Run it from
the primary node.
3) From the new node, run the same SP as is installed on the primary.
4) Fail over to the new node and apply any post-SP hotfixes.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
[quoted text, click to view] "BC DBA" <BCDBA@discussions.microsoft.com> wrote in message
news:37AF98A0-50D9-452E-9504-E1A889BE8E49@microsoft.com...
Tom,
I can appreciate that, unfortunately my employeer is not going to spring for
a training course :( A trip to the US would be something that I would enjoy
too much :)
--
Regards
Tony
[quoted text, click to view] "Tom Moreau" wrote:
> This is something you really shouldn't do without proper training. Check
> out
www.clusterhelp.com. >
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
>
https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "BC DBA" <BCDBA@discussions.microsoft.com> wrote in message
> news:F021995A-78EA-4FF6-B32F-86D01E4300FD@microsoft.com...
> Well the subject pretty much covers it, We have a Single node cluster
> running
> SQL 2000 on windows 2003 Server, having completed the construction of our
> second datacentre, we now need to add a second node to it. Unfortunately
> the
> suppliers who set up the original cluster are long gone, and have left us
> no
> instructions on how to add this second node.
>
> Can anyone point me in the direction of some documentation. Ideally we
> would
> like to minimise the downtime of the live system.
>
> --
> Regards
>
> Tony
>
>
