Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Automatic Mirroring fail over and see Login failed errors in error log of current Mirror server Expand / Collapse
Posted Friday, July 18, 2014 9:08 AM


Group: General Forum Members
Last Login: 2 days ago @ 9:21 AM
Points: 2,751, Visits: 5,187
Urgh, mirroring nomenclature.
I tend to use:
Primary & Secondary - Server and FailoverPartner respectively (or, Primary = the server you expect to be the 'live' one most of the time).
These titles always refer to the same server.

Principal & Mirror - refer to whichever server is carrying out that role at the time.

So, the errors are on the Primary Server when it is carrying out the Mirror role.
Post #1594112
Posted Thursday, July 24, 2014 2:59 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, February 28, 2015 10:12 AM
Points: 329, Visits: 1,019
Agree with Gazareth.
The app will try Primary first. When it is acting as the mirror, the login attempt cannot open the mirror database, and thus fails.

Post #1596031
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse