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

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