I'm running MSSQL 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 into
In Recovery mode on the SQL instance that was restarted.
I have no problem setting up a mirrored database and I can fail-over with no problem between the principal or the mirror but any time I restart the
MSSQLSERVER service everything breaks.
After the database is set to
In Recovery mode it is impossible to get it out of it. The only option is to delete (
drop) the database.
Alter Database TestDB SET PARTNER OFF generates the following error:
Msg 945, Level 14, State 2, Line 1
Database 'TestDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Restore Database TestDB WITH RECOVERY generates the following error:
Msg 3104, Level 16, State 1, Line 1
RESTORE cannot operate on database 'TestDB' because it is configured for database mirroring or has joined an availability group. If you intend to restore the database, use ALTER DATABASE to remove mirroring or to remove the database from its availability group. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.*
Is database mirroring broken on 11.0.2100 or do I have some kind of permission problem?