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 ««12

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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:36 AM
Points: 2,003, Visits: 3,409
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 17, 2014 4:56 PM
Points: 282, Visits: 887
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