SQL Server Database In Single User Mode after Failover
- by jlichauc
Here is a weird situation we experienced with a SQL Server 2008 Database Mirroring Failover.
We have a pair of mirrored databases running in high-availability mode and both the principal and mirror showed as synchronized. As part of some maintenance I triggered a manual failover of the principal to the mirror. However after the failover the…