Home / server / Questions / 442393
In Process
CWL
Asked: 2012-10-26 08:45:03 +0800 CST

SQL 2008 R2 Mirroring Issue

  • 772

Windows 2008 R2 with SQL 2008 R2 - Using Mirroring of a Database across the WAN in a HA setup with one witness.

One issue I am having is during a failure (ever so often) the system fails over or tries, but leaves both databases in a Restoring State. My guess is the failover issue happens when there is a WAN bouncing and the systems get confused. The usual fix is to reboot the sql servers.

Has anyone seen this type of failure? While this does not happen often it does causes an issue and concern with HA not being trusted fully.

sql-server

1 Answers

  1. Are there multiple data centers involved? Where is the witness located in relation to the principal and mirror when this occurs?

    If the principal loses connectivity to the witness and mirror, then it will shutdown as well.

    If the WAN is bouncing as you suggest, perhaps the principal fails over to the mirror, thus becoming the principal.

    Then, if the WAN goes down a second time, the new principal just lost connectivity to both the witness and the mirror and then goes offline itself.

    • 0