1

Restarting MSSQLSERVER service on the principal or on the mirror the database is set in "In Recovery" mode

view story
linux-howto

http://serverfault.com – I'm running SQL Server 11.0.2100 (SQL Server 2012) and every time I restart the MSSQLSERVER service on the principal or on the mirror, the database mirror breaks and the database is set in In Recovery mode on the SQL instance that was restarted (principal or mirror). I have no problem setting up a mirrored database and I can fail-over with no problem between the principal or the mirror but every time I restart the MSSQLSERVER service everything breaks. After the database is set in In Recovery mode it is impossible to get it out of it. The only option is to delete (drop) the database. Runnin (HowTos)