5
votes
2answers
955 views

Manually moving SQL instance to another node causes immediate database mirror failover

I have a two-node SQL cluster (2008 R2). Some of the databases within that SQL instance are mirrored to another server on a remote site, using the High safety with automatic failover. The mirroring ...
4
votes
1answer
162 views

SQL Server Mirroring kicks in before cluster has time to fail over

I have two clusters each with two nodes configured in active/passive; the two clusters take part in a high-availability mirroring session using a separate server as the witness. When a node fails in ...