Sqlserver 2008 R2 Mirroring failed to failover when the primary server got stacked.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Sqlserver 2008 R2 Mirroring failed to...

Sqlserver 2008 R2 Mirroring failed to failover when the primary server got stacked.

Rate Topic

Display Mode

Topic Options

Author

Message

ronnigodfrey

Posted Tuesday, February 26, 2013 5:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 06, 2013 6:13 AM
Points: 3, Visits: 15

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

Minaz

Posted Wednesday, February 27, 2013 8:44 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 6:56 AM
Points: 535, Visits: 1,426

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 »

Permissions