Sample Header Ad - 728x90

ola-hallengren running full backups and log backups at the same time-- restore issues?

0 votes
1 answer
286 views
I recently ran across an issue trying to restore a db and log files. DB restored without issues. About 10 log files in, I received a message stating the LSN was out of sync and could not finish. I used a tool that puts them in order, so that's not my issue. I have my log backups set to run in 15 minute intervals. This large database takes a couple of hours to perform a full backup. Could the log backups happening simultaneously during the full backup cause this situation? The end result was not bad this time, but this is alarming. I am trying to maintain a RPO of 15 minutes. This little test resulted in an 8 hr RPO.... unacceptable. Regards, Tim
Asked by Tim Shelton (1 rep)
Dec 14, 2020, 06:52 PM
Last activity: May 21, 2025, 11:07 AM