muthyala_51 (7/18/2014)
Gazareth (7/17/2014)
Sorry, bad grammar on my part!I mean that is the expected behaviour.
But i am seeing like thousands of thousands login failure for every sec, is this really expected behaviour?
They stopped when i failed back the databases to primary and i don't see that behavior on Mirror server , why?
Because they never attempt to connect to the mirror in that situation.
If your connection string is Server=Server1;FailoverPartner=Server2
When Server1 is primary:
App tries to connect to Server1 -- Success!
When Server2 is primary:
App tries to connect to Server1 -- Failure <-- this causes the errors you're seeing
-> App tries to connect to Server2 -- Success!