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

Sqlserver 2008 R2 Mirroring failed to failover when the primary server got stacked. Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 5:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:11 AM
Points: 4, Visits: 27
Question:

Sqlserver 2008 R2 Mirroring failed to failover when the primary server got stacked.
Environment: 3 virtual servers: Primary, secondary and witness
No errors were found in the event log , in the sqlserver logs and in the application.




Post #1424028
Posted Wednesday, February 27, 2013 8:44 PM


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: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
There are many questions as What type of configuration was it high safety mode or high performance mode?

If this is set with high performance mode with winthness server then there is risk associate with it


When a witness is set in a high-performance mode session and If the principal server is lost, forcing service to the mirror server requires that the mirror server be connected to the witness.

If the mirror server is lost, the principal server must be connected to the witness. Otherwise, the principal server takes its database offline until either the witness or mirror server rejoins the session.

Hence please check the configuration.





"More Green More Oxygen !! Plant a tree today"
Post #1424862
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse