Error:

The remote copy of database x has not been rolled forward to a point in time that is encompassed in the local copy of the database log

Fix:

Make sure you disable existing log backup job that is automatically backing up the log file.

Fix 2:

The only thing that I can think of is that maybe there is a job that is automatically backing up the log file on the principal?

Generally you have to backup one log file and restore it on the mirror before you can setup mirroring. Also, any log backup you do since the full backup must be restored on the mirror.

But basically the error message says it needs more log. Go ahead and backup the log again, restore it and try again.

Sources:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3916b3cd-f8f1-4471-9ed9-cdb32dce242a/the-remote-copy-of-database-x-has-not-been-rolled-forward-to-a-point-in-time-that-is-encompassed-in?forum=sqldatabasemirroring

Last modified: March 30, 2022

Author

Comments

Write a Reply or Comment