Red Gate forums :: View topic - 7.1 Cluster Failover provoked on Passive Node upgrade
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

7.1 Cluster Failover provoked on Passive Node upgrade

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 503
Location: Costa Mesa, CA, USA

PostPosted: Wed Jun 27, 2012 6:22 pm    Post subject: 7.1 Cluster Failover provoked on Passive Node upgrade Reply with quote

I just upgraded the Active Node, then the Passive Node, just as I usually do.

On the Active Node, everything went per usual:
    Update the GUI
    Navigate to the 32-bit Program Files and run the Service Update manually.
On the Passive Node, I followed the same process BUT at the end of the service upgrade I was presented with:
Code:
ALERT NAME: Cluster resource failed
TIME: 6/27/2012 12:02:49 PM
REASON:
Cluster resource SQL Backup Agent in clustered service or application SQL Group failed.
SEVERITY: CRITICAL

Little did I know but I had just inadvertently provoked a cluster failover! EEK!

Highly unexpected. What did I do wrong? Or is there an issue with the installer on a Passive Node?
Back to top
View user's profile Send private message
Marianne



Joined: 03 Oct 2011
Posts: 45

PostPosted: Thu Jun 28, 2012 12:17 pm    Post subject: Reply with quote

Hi,

Many thanks for your post. I need a bit more information from you. Can you confirm that you were running SQBServerSetup.exe manually to install the server components (it sounds like it, but I just want to double check)?
If so, were you following the instructions on installing the server components on clusters (http://www.red-gate.com/SupportCenter/Content/SQL_Backup/help/7.1/SBU_InstallingonaSQLServerCluster) and did you disable the SQL Backup resource in Cluster Administrator before upgrading? If not, could you try following those steps?

Cheers,

Marianne
_________________
Marianne Crowder
Red Gate Software Limited
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 503
Location: Costa Mesa, CA, USA

PostPosted: Thu Jun 28, 2012 5:33 pm    Post subject: Reply with quote

Yes, I was using the .exe as quoted.

No, I'd completely forgotten about disabling the cluster resource on the passive node - not overly familiar with cluster management as I'm only an accidental DBA.

Could I ask Red Gate to "Please add a dialog box so that when upgrading a SQL Backup Server component on a Passive node it reminds (forgetful/inexperienced/non-admin) users to disable the cluster resource temporarilly." This will help IMMENSELY and prevent others making the same mistake I did!

Cheers!

Stephen
Back to top
View user's profile Send private message
Marianne



Joined: 03 Oct 2011
Posts: 45

PostPosted: Thu Jun 28, 2012 5:37 pm    Post subject: Reply with quote

Hi Stephen,

Many thanks for the feedback - I'll add the feature request to our list.

Cheers,

Marianne
_________________
Marianne Crowder
Red Gate Software Limited
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Thu Jun 28, 2012 5:52 pm    Post subject: Reply with quote

Stephen,

I have made changes to clusters many times on Windows 2003R2 and usually update the GUI on the passive side and then go to the active side and update the GUI followed by the server components without mentioning it is clustered without problems. I have never had the chance to do this on Windows 2008 or Windows 2008R2.

Was your experience on Windows 2008 or Windows 2008R2 as you didn't mention the O/S?

Thanks

Chris
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 503
Location: Costa Mesa, CA, USA

PostPosted: Thu Jun 28, 2012 5:56 pm    Post subject: Reply with quote

Hi Chris (fellow Brit),

Windows Server 2008 Enterprise.

Regards,

Stephen
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Thu Jun 28, 2012 5:59 pm    Post subject: Reply with quote

Good to know that there is danger lurking with newer O/S'es.

Thanks

Chris
_________________
English DBA living in CANADA
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group