5

What happens when Mirror times out with Principal, but Principal does not timeout with Witness or Mirror?

view full story
linux-howto

http://serverfault.com – We have three SQL server 2008 r2 servers (principal, mirror and witness) setup for mirroring (with safety option). I see in the Mirror server logs that there was a "The mirroring connection to TCP://PRINCIPAL:1234 has timed out" error for databaseA. However I do not see a similar error in the Principal server log. A failover did not occurr. So from what I understand the Mirror was able to communicate with the Witness and but not the Principal. The log entries after that in the Mirror server are: Database mirroring is inactive for database 'databaseA'. Starting up database 'databaseA'. B (HowTos)