Monday, February 13, 2012

After Install WIN2K3 SP1 on SQL 2K SP3 Cluster Problem

My site have two HP server are install SQL 2K Cluster Server (MSCS) on
Windows 2003 Server are running smoothly but when I upgrade both Windows 2003
to SP1 the problem was appear, when I reboot Passive B cluster server it will
take over the SAN disk(the database disk) but it doesn't failover the SQL
process, I'm sure I didn't set failback to passive server.
When I manual to failover from Active A Cluster to passive B server, it can
success to failover to B, then I restart A Cluster server, it can takeover
all process and SAN disk back, I'm also sure I didn't set failback to A
Server.
So, could you mind give me some hints for me to trouble shooting, I hear
before most of the cases are cause of Windows 2003 SP1.
Make sure that you HBA's are certified to run under SP1, this is not always
the case. You may need to update the drivers after SP1. Worse case,
uninstall SP1 until the vendor supports SP1.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"TM" <TM@.discussions.microsoft.com> wrote in message
news:17C5D515-8B5B-4C4F-9E0F-4FFE1375D145@.microsoft.com...
> My site have two HP server are install SQL 2K Cluster Server (MSCS) on
> Windows 2003 Server are running smoothly but when I upgrade both Windows
> 2003
> to SP1 the problem was appear, when I reboot Passive B cluster server it
> will
> take over the SAN disk(the database disk) but it doesn't failover the SQL
> process, I'm sure I didn't set failback to passive server.
> When I manual to failover from Active A Cluster to passive B server, it
> can
> success to failover to B, then I restart A Cluster server, it can takeover
> all process and SAN disk back, I'm also sure I didn't set failback to A
> Server.
> So, could you mind give me some hints for me to trouble shooting, I hear
> before most of the cases are cause of Windows 2003 SP1.

No comments:

Post a Comment