SQL Mirror has two principals at a time

in Citrix VDI projects, there are often many SQL mirror, but sometimes the switch-in, DB01 and DB03 colleague shutdown, this phenomenon, there are two can be resolved by the following command:

The command must be executed to force the DB02 switch to the subject: ALTER database PRPVSDB001 (database name) SET PARTNER Force_service_allow_data_loss that is, the database service is OK

This article is from the "liy-l" blog, make sure to keep this source http://liy116.blog.51cto.com/2991406/1656364

SQL Mirror has two principals at a time