SQL Server: Gaps in the sequence of Transaction Log Backups

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hello Everyone,

A good day to all!

What is the workaround when you encounter a break in the "log chain" when your Validated Sync Mode is set through Transaction Log Backups (Log Sync Disabled)?

I've encountered this scenario when I was conducting a POC wherein it stopped collecting the logs which led to the dSource not updating. I've tried doing a manual snapshot of a full backup (which I've already copied to the backup path where the logs are being dumped) but there's an error informing me that it's not seeing or getting any valid recent full backup.

Thanks in advance to those who would help out.
Photo of Mark

Mark

  • 310 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Ankur Sarin

Ankur Sarin, Employee

  • 460 Points 250 badge 2x thumb
Official Response
Could you post the error that you are seeing?

Did you select the "Most Recent Backup" option when doing the manual snapshot? In that case, it looks for the latest Full or Differential backup based on msdb.dbo.backupset in the backup location. Does that backup exist there?

If you want to take the snapshot using a specific full backup, you need to select the "Specific Backup" option, and provide its backup UUID when doing the manual snapshot. The backup would have to be more recent than the latest log backup that was ingested.

Do let us know if this solves the issue that you are seeing.