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?
thksYou 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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment