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)
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:
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
Post a Comment