I have a 3 node cluster based on a Win2003 Server which is running SP1. Each
physical node also has one named instance of SQL Server 2000 Enterprise with
SP4 which can failover to any other of the 2 nodes.
My question is I'm looking to see what the process would be to temprorarily
evict one physical node and its server instance for a period of time and
later have that node rejoin the cluster.
Is their any re-installation thats required of either the cluster or the SQL
instance?
Would it make any diference if after evicting the physical node if I created
another temporary named instance on that node and then later removed prior
to re-joining it to the cluster?
thks
You must run the SQL installation and remove the node from each instance's
allowed nodes. Look up "Maintaining a Failover Cluster" in BOL.
You will need to re-add the node to the cluster and then re-run the SQL
installer (and any hotfixes) to re-enable each instance for SQL Server.
Again, BOL is your friend here.
You can install a non-clustered instance on a system and then bring it into
a cluster. The clustered instance and the named instance will not confluct,
as long as disk usages and names do not collide. You will still need to
re-run the SQL installer fore each clustered instance whether or not there
are any SQL instances already on the node.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Tom Frost" <frosty@.nospam.nospam> wrote in message
news:99F01D04-63BE-4569-B483-48284C2CD525@.microsoft.com...
>I have a 3 node cluster based on a Win2003 Server which is running SP1.
>Each
> physical node also has one named instance of SQL Server 2000 Enterprise
> with
> SP4 which can failover to any other of the 2 nodes.
> My question is I'm looking to see what the process would be to
> temprorarily
> evict one physical node and its server instance for a period of time and
> later have that node rejoin the cluster.
> Is their any re-installation thats required of either the cluster or the
> SQL
> instance?
> Would it make any diference if after evicting the physical node if I
> created
> another temporary named instance on that node and then later removed
> prior
> to re-joining it to the cluster?
> thks
>
No comments:
Post a Comment