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)

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:

Restore database WITH NORECOVERY

When you restore the transaction log, ensure RESTORE WITH NORECOVERY is selected:

Restore transaction log WITH NORECOVERY

The database on the instance you want to mirror with should be in a (Restoring...) state:

Database restoring state

Comments

Popular posts from this blog

LG TV This app will now restart to free up more memory

LG TV Clear All Browsing History Data

LG TV turn off Quick Start in settings