Tag Archives: mirroring

Database mirroring cannot be enabled because the database is not in full recovery mode on both partners

Recently I had worked on a mirroring issue. While initializing mirroring, an error message as shown in the below screenshot is encountered.

mirror2

Here’s how this issue was fixed

  • Check if the recovery model of the database on the Prinicipal Server was set to FULL. <– Yes, it was.
  • Take the full database backup of the database on the Prinicpal server
  • Take the transaction log backup of the database on the Principal Server
  • Restore the full database backup on the mirrored instance WITH NORECOVERY
  • Restore the transaction log backup on the mirrored instance WITH NORECOVERY

Configure Mirroring again.