Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL servers service failure Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2012 10:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:45 AM
Points: 94, Visits: 319
During failover from NODE02 to NODE01, as part of our patching activity, we found that SQL Server services are failing during the failover to other node: NODE01 in order to move the services to the previous state....

Post #1384761
Posted Wednesday, November 14, 2012 8:05 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:26 PM
Points: 316, Visits: 1,497
What does the sql errorlog show?
Post #1384953
Posted Thursday, November 15, 2012 11:01 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:21 AM
Points: 529, Visits: 1,567
Which version of SQL and which patch?

This sounds similar to my issue (which is posted in this section but has had no responses yet) where we added SQL 2008 R2 SP2 to a passive node (R2 RTM) and now SQL Service won't start when we attempt a failover. The SQL Log doesn't help because the failure occurs before the log starts writing, and all the Windows logs say is that the Cluster's start command times out.
Post #1385279
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse