First published on MSDN on Dec 05, 2012
This error surprised me when it showed up in the error log so I decided to dig into it a bit more.
“Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed on the primary. This is an informational message only.
Preserve this log backup along with the other log backups of this database.”
The message appears on the secondary replica, where the backup was taken, and indicates one of two possible conditions. To understand the conditions it helps to understand the state of the backup operation.
The error occurs after the point where the backup was successfully streamed to the backup media. The first concern I had was “is my backup valid” and the answer is YES! The backup has been written to the backup media properly.
Now the secondary sends a message to the primary to update the backup position in the database. If this message fails the error is logged.
1. The secondary sends the completed message to the primary. The primary records the backup position but for some reason fails to respond the secondary (I.E. lost network connection.) In this case the next backup will pick up were the current backup completed.
2. The secondary sends the completed message to the primary. The primary never receives the message or fails in some way before it can record the current backup position. (I.E. network, primary shut down, etc…). In this case the next backup will acquire the same information as the last log backup and any additional log records generated.
As you can see the message may be a bit alarming but it is harmless to your backup strategy other than the fact that you might get extra log records in a backup but that can be properly handled during restore. NO DATA LOSS!
Bob Dorr - Principal SQL Server Escalation Engineer