Rebuild one node of an active/passive cluster

Is there a documentation on how to rebuild one node of an active/passaive SQL
Server cluster from the O/S up with the SQL Server in use by the other node?
Sort of. Your OS build should be documented in your disaster recovery
documents since it is your unique installation. The steps to add it back in
as a cluster member and a working SQL server are documented in BOL under the
topic 'Maintaining a Failover Cluster'.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:2F3CB6D3-5AFD-49F3-A66B-734E7A772197@.microsoft.com...
> Is there a documentation on how to rebuild one node of an active/passaive
SQL
> Server cluster from the O/S up with the SQL Server in use by the other
node?
>
sql

Rebuild one node of an active/passive cluster

Is there a documentation on how to rebuild one node of an active/passaive SQL
Server cluster from the O/S up with the SQL Server in use by the other node?
Tom,
You might want to post this in .clustering.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Tom wrote:
> Is there a documentation on how to rebuild one node of an active/passaive SQL
> Server cluster from the O/S up with the SQL Server in use by the other node?

Rebuild one node of an active/passive cluster

Is there a documentation on how to rebuild one node of an active/passaive SQ
L
Server cluster from the O/S up with the SQL Server in use by the other node?Tom,
You might want to post this in .clustering.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Tom wrote:[vbcol=seagreen]
> Is there a documentation on how to rebuild one node of an active/passaive
SQL
> Server cluster from the O/S up with the SQL Server in use by the other node?[/vbco
l]

Rebuild one node of an active/passive cluster

Is there a documentation on how to rebuild one node of an active/passaive SQL
Server cluster from the O/S up with the SQL Server in use by the other node?Tom,
You might want to post this in .clustering.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Tom wrote:
> Is there a documentation on how to rebuild one node of an active/passaive SQL
> Server cluster from the O/S up with the SQL Server in use by the other node?

Rebuild one node from SQL Cluster

hi guys,
I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
is on Active/Passive config. One of the node giving problem and i am planning
to rebuild it until this question strikes my mind. After rebuild, how do i
join back to existing SQL Cluster?
TIA
oh...it's k...i got it
http://www.microsoft.com/technet/pro...rt4/c1261.mspx
"Adding or Removing a Cluster Node from the Virtual Server Definition
Another new feature of SQL Server 2000 failover clustering is the ability to
add or remove a cluster node from a SQL Server virtual server definition.
Adding nodes to the existing SQL Server virtual server definition performs
all the necessary operations on the new nodes (including installing binaries,
system components, and creating services) and performs the necessary
modifications to the cluster configuration. "
"rupart" wrote:

> hi guys,
> I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
> is on Active/Passive config. One of the node giving problem and i am planning
> to rebuild it until this question strikes my mind. After rebuild, how do i
> join back to existing SQL Cluster?
> TIA
|||You'll get the right audience looking at this if you plst to
ms.p.sqlserver.clustering.
There are these links
http://www.microsoft.com/technet/pro.../failclus.mspx
http://www.microsoft.com/downloads/d...displaylang=en
http://www.sql-server-performance.co...stall_main.asp
http://support.microsoft.com/?kbid=301600
Which should help but some questions first.
What SP level is the OS and SQL currently at?
There are issues adding back failed nodes to SP4 level (I had them).
Also you must follow certain guidelines when evicting/adding nodes otherwise
you could render your cluster unusable.
Also have a backup plan in case this actually does happen. I restored the
critical databases to another cluster just prior to doing the actual work on
a live system just in case it all went wrong.
Also if you have access to a "virtual server system" Virtual Server 2005 or
VMWare create a system similar to you current one to try the process out.
Nik Marshall-Blank MCSD/MCDBA
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:7BE08633-F659-4B34-9F5E-806A3550CA02@.microsoft.com...
> hi guys,
> I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
> is on Active/Passive config. One of the node giving problem and i am
> planning
> to rebuild it until this question strikes my mind. After rebuild, how do i
> join back to existing SQL Cluster?
> TIA

Rebuild one node from SQL Cluster

hi guys,
I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
is on Active/Passive config. One of the node giving problem and i am planning
to rebuild it until this question strikes my mind. After rebuild, how do i
join back to existing SQL Cluster?
TIAoh...it's k...i got it
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1261.mspx
"Adding or Removing a Cluster Node from the Virtual Server Definition
Another new feature of SQL Server 2000 failover clustering is the ability to
add or remove a cluster node from a SQL Server virtual server definition.
Adding nodes to the existing SQL Server virtual server definition performs
all the necessary operations on the new nodes (including installing binaries,
system components, and creating services) and performs the necessary
modifications to the cluster configuration. "
"rupart" wrote:
> hi guys,
> I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
> is on Active/Passive config. One of the node giving problem and i am planning
> to rebuild it until this question strikes my mind. After rebuild, how do i
> join back to existing SQL Cluster?
> TIA|||You'll get the right audience looking at this if you plst to
ms.p.sqlserver.clustering.
There are these links
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=96f76ed7-9634-4300-9159-89638f4b4ef7&displaylang=en
http://www.sql-server-performance.com/sqlserver2000_clustering_install_main.asp
http://support.microsoft.com/?kbid=301600
Which should help but some questions first.
What SP level is the OS and SQL currently at?
There are issues adding back failed nodes to SP4 level (I had them).
Also you must follow certain guidelines when evicting/adding nodes otherwise
you could render your cluster unusable.
Also have a backup plan in case this actually does happen. I restored the
critical databases to another cluster just prior to doing the actual work on
a live system just in case it all went wrong.
Also if you have access to a "virtual server system" Virtual Server 2005 or
VMWare create a system similar to you current one to try the process out.
--
Nik Marshall-Blank MCSD/MCDBA
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:7BE08633-F659-4B34-9F5E-806A3550CA02@.microsoft.com...
> hi guys,
> I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
> is on Active/Passive config. One of the node giving problem and i am
> planning
> to rebuild it until this question strikes my mind. After rebuild, how do i
> join back to existing SQL Cluster?
> TIAsql

Rebuild one node from SQL Cluster

hi guys,
I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
is on Active/Passive config. One of the node giving problem and i am plannin
g
to rebuild it until this question strikes my mind. After rebuild, how do i
join back to existing SQL Cluster?
TIAoh...it's k...i got it
[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1261.mspx[/url
]
"Adding or Removing a Cluster Node from the Virtual Server Definition
Another new feature of SQL Server 2000 failover clustering is the ability to
add or remove a cluster node from a SQL Server virtual server definition.
Adding nodes to the existing SQL Server virtual server definition performs
all the necessary operations on the new nodes (including installing binaries
,
system components, and creating services) and performs the necessary
modifications to the cluster configuration. "
"rupart" wrote:

> hi guys,
> I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
> is on Active/Passive config. One of the node giving problem and i am plann
ing
> to rebuild it until this question strikes my mind. After rebuild, how do i
> join back to existing SQL Cluster?
> TIA|||You'll get the right audience looking at this if you plst to
ms.p.sqlserver.clustering.
There are these links
http://www.microsoft.com/technet/pr...n/failclus.mspx
http://www.microsoft.com/downloads/...&displaylang=en
http://www.sql-server-performance.c...om/?kbid=301600
Which should help but some questions first.
What SP level is the OS and SQL currently at?
There are issues adding back failed nodes to SP4 level (I had them).
Also you must follow certain guidelines when evicting/adding nodes otherwise
you could render your cluster unusable.
Also have a backup plan in case this actually does happen. I restored the
critical databases to another cluster just prior to doing the actual work on
a live system just in case it all went wrong.
Also if you have access to a "virtual server system" Virtual Server 2005 or
VMWare create a system similar to you current one to try the process out.
Nik Marshall-Blank MCSD/MCDBA
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:7BE08633-F659-4B34-9F5E-806A3550CA02@.microsoft.com...
> hi guys,
> I have SQL Cluster running on 2 servers running on Win2k3. The SQL Cluster
> is on Active/Passive config. One of the node giving problem and i am
> planning
> to rebuild it until this question strikes my mind. After rebuild, how do i
> join back to existing SQL Cluster?
> TIA

Rebooting Cluster Boxes

Hi

I am a 2 node active/passive 2003 cluster. I have some maintenace where I need to shut down both of the servers at the same time.

Has anyone experience any issue in this approach?

I am planning to take the cluster offline and then shutdown the servers and bring it online after the reboot. I am also running SQL so any concerns or tips as what would be the best scenario.

Hoping to get some reply.

Thanks
Anup

See this KBA http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster readme about how you can handle such on the cluster.

But make sure you have complete backups for system and user databases to ensure to recover when something is wrong.

Reboot? How often?

We currently have SQL server EE running on Windows Server 2003 EE in a 2 node
active/passive cluster. We want to restart periodically but not too often.
What is the best way to do this? What I've been doing is move the resources
to the inactive side of the cluster then rebooting the passive node. Then
next time move them back using cluster administrator then rebooting the other
box. Anyone see any potential issues with this approach? Thanks.
Tom
That works, but why do you want to reboot? Are you talking about software/OS
updates.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"rk rider" <rkrider@.discussions.microsoft.com> wrote in message
news:EA70D7F1-C143-4B63-A32D-A59FFC422E1C@.microsoft.com...
> We currently have SQL server EE running on Windows Server 2003 EE in a 2
> node
> active/passive cluster. We want to restart periodically but not too often.
> What is the best way to do this? What I've been doing is move the
> resources
> to the inactive side of the cluster then rebooting the passive node. Then
> next time move them back using cluster administrator then rebooting the
> other
> box. Anyone see any potential issues with this approach? Thanks.
> Tom
|||Because the VP of our dept thinks servers need to be rebooted on a regular
schedule. Personally I see no real reason althought it's nice to test the
fail over periodically in a controlled manner. Personally however, I see no
compelling reason given the stability of Windows server these days. I just
looking for a best practices approach.
"Rodney R. Fournier [MVP]" wrote:

> That works, but why do you want to reboot? Are you talking about software/OS
> updates.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> "rk rider" <rkrider@.discussions.microsoft.com> wrote in message
> news:EA70D7F1-C143-4B63-A32D-A59FFC422E1C@.microsoft.com...
>
>
|||That is what I am getting at, if you patch monthly then you will reboot
monthly
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"rk rider" <rkrider@.discussions.microsoft.com> wrote in message
news:2C3511EB-E75E-4B8F-8A73-53A608994E08@.microsoft.com...[vbcol=seagreen]
> Because the VP of our dept thinks servers need to be rebooted on a regular
> schedule. Personally I see no real reason althought it's nice to test the
> fail over periodically in a controlled manner. Personally however, I see
> no
> compelling reason given the stability of Windows server these days. I just
> looking for a best practices approach.
> "Rodney R. Fournier [MVP]" wrote:
|||The only issue that I see with it is that you blow away your cache, so when
the SQL Server starts back up, it has to incrementally repopulate that as
queries come in. That leads to performance degradation and heavy
utilization on your disk drives. I see no reason to just arbitrarily reboot
a server, at all. If I have to apply a service pack or hotfix that requires
rebooting, then I obviously reboot. But, that is the only time that I
reboot a machine. If it ain't broke, don't fix it.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"rk rider" <rkrider@.discussions.microsoft.com> wrote in message
news:EA70D7F1-C143-4B63-A32D-A59FFC422E1C@.microsoft.com...
> We currently have SQL server EE running on Windows Server 2003 EE in a 2
> node
> active/passive cluster. We want to restart periodically but not too often.
> What is the best way to do this? What I've been doing is move the
> resources
> to the inactive side of the cluster then rebooting the passive node. Then
> next time move them back using cluster administrator then rebooting the
> other
> box. Anyone see any potential issues with this approach? Thanks.
> Tom
|||I agree with the other replies. Windows 2003 is orders of magnitude more
stable than NT 4.0. Your VP needs to update his technical skills or at
least admit that Windows 95 is not the Gold Standard for operating systems
any more.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"rk rider" <rkrider@.discussions.microsoft.com> wrote in message
news:EA70D7F1-C143-4B63-A32D-A59FFC422E1C@.microsoft.com...
> We currently have SQL server EE running on Windows Server 2003 EE in a 2
> node
> active/passive cluster. We want to restart periodically but not too often.
> What is the best way to do this? What I've been doing is move the
> resources
> to the inactive side of the cluster then rebooting the passive node. Then
> next time move them back using cluster administrator then rebooting the
> other
> box. Anyone see any potential issues with this approach? Thanks.
> Tom
|||rk rider wrote:
> We currently have SQL server EE running on Windows Server 2003 EE in
> a 2 node active/passive cluster. We want to restart periodically but
> not too often. What is the best way to do this?
When there are hotfix that require to be applied I install them on the
passive node and reboot it immediately.
Then I download and install it on active node and I schedule a shutdown
(using shutdown.exe or psshutdown from sysinternals) for the following
night.
So, usually I shutdown the system monthly but only if there are high
priority hotfix available...

> Tom
Bye
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com

Reboot SAN of SQL Cluster

We are planning a recycle of our SAN to which our active/passive 2-node SQL
cluster is attached. Is there anything special to be aware of?
We will do the following steps:
Pause the passive node
using Cluster Admin, stop SQL service
Power down active node server
power down passive node server
after SAN recycle complete
Power up active node server
power up passive node server
restart (resume) passive node
Any insight is greatly appreciated!!
Go ahead and take the entire SQL resource group offline. Then take the
cluster group offline. Down the host nodes, reboot the SAN, then restart
the nodes one at a time.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:78418060-D070-4AEE-BBD7-83D3D827069E@.microsoft.com...
> We are planning a recycle of our SAN to which our active/passive 2-node
> SQL
> cluster is attached. Is there anything special to be aware of?
> We will do the following steps:
> Pause the passive node
> using Cluster Admin, stop SQL service
> Power down active node server
> power down passive node server
> after SAN recycle complete
> Power up active node server
> power up passive node server
> restart (resume) passive node
> Any insight is greatly appreciated!!
|||If you are on a geo cluster (2 disk arrays replicated via a dedicated
technology), first restart the node which was stopped last (for cluster
service).
Guillaume.
==================
"RobinMC" wrote:

> We are planning a recycle of our SAN to which our active/passive 2-node SQL
> cluster is attached. Is there anything special to be aware of?
> We will do the following steps:
> Pause the passive node
> using Cluster Admin, stop SQL service
> Power down active node server
> power down passive node server
> after SAN recycle complete
> Power up active node server
> power up passive node server
> restart (resume) passive node
> Any insight is greatly appreciated!!