Database is not configured for database mirroring. (Microsoft SQL Server, Error: 1416)
This post describes how to fix the error:
An error occurred while starting mirroring.
Database is not configured for database mirroring. (Microsoft SQL Server, Error: 1416)
Cause
This error can occur if RESTORE WITH NORECOVERY was not used when restoring either the database or the transaction log on the mirror SQL instance.
Resolution
When you restore the database, ensure RESTORE WITH NORECOVERY is selected:
When you restore the transaction log, ensure RESTORE WITH NORECOVERY is
selected:
The database on the instance you want to mirror with should be in a (Restoring...) state:
Related Posts
- The client and server cannot communicate, because they do not possess a common algorithm
- Database cannot be opened. It is in the middle of a restore. (Error 927)
Comments
Post a Comment