Database might contain bulk logged changes that have not been backed up (Microsoft SQL Server, Error: 1475)

This post describes how to fix the error:
An error occurred whilst starting mirroring.
Database might contain bulk logged changes that have not been backed up. Take a log backup on the principal database or primary database. (Microsoft SQL Server, Error: 1475)

Database might contain bulk logged changes that have not been backed up (Microsoft SQL Server, Error: 1475)

Cause

This error can occur when you attempt to start mirroring but the database you are trying to mirror from (the principal database) has not had a Transaction Log backup.

Resolution

On the database that you wish to mirror (the principal database), perform a Transaction Log backup:

Back Up Database Backup Type Transaction Log

Then restore this backup on the mirror database, ensuring you use RESTORE WITH NORECOVERY.  Failure to do this will result in the error: Database is not configured for database mirroring. (Microsoft SQL Server, Error: 1416)


Comments