Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
Antoine F
Novice
Posts: 3
Liked: never
Joined: Nov 13, 2019 2:33 pm
Full Name: Antoine Forget
Contact:

Broken log sequence chain detection

Post by Antoine F »

With regards to SQL backups, does Veeam have a mechanism to handle broken log sequence when performing backups.

e.g. option to perform a full when broken chain happens or detection and alerting or some other mechanism.
Gostev
Chief Product Officer
Posts: 31460
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Broken log sequence chain detection

Post by Gostev »

We use native SQL Server capability to perform transaction log backups, so in the above scenario the log backup will fail with the corresponding error message logged because SQL Server itself will spot the inconsistency (and we will pass on the error message into the job session log). Thanks!
Antoine F
Novice
Posts: 3
Liked: never
Joined: Nov 13, 2019 2:33 pm
Full Name: Antoine Forget
Contact:

Re: Broken log sequence chain detection

Post by Antoine F »

Thanks Gostev,

If we talk about the native SQL backup, usually LSN errors occur during the "restore".
The backup does not generate LSN error exept maybe if there was no initial full backup which might be a different error.

However, some backup solutions keep track of the LSN when performing the backup and therefore detect if a LSN is missing due to a conflicting backup solution.

I am trying to figure if Veeam has means to detect issues before the need for the restore arise either through regular restore tests.

If not, I would like to know if there are planned alternatives like restoring the full backup and transaction log backup files from both conflicting systems and applying them manually.

Thanks again
Post Reply

Who is online

Users browsing this forum: No registered users and 28 guests