Comprehensive data protection for all workloads
Post Reply
jround
Enthusiast
Posts: 37
Liked: 6 times
Joined: Jun 04, 2019 3:01 pm
Contact:

SQL server forever forward incremental with transaction log backup

Post by jround »

We have a SQL server VM with several databases in 'full' recovery mode

Veeam has a forever forward incremental job for the VM running at 20:00 daily which I assume counts as the 'full' SQL DB backup should we ever need to recover it

As it is a business critical system I set up 'Process transaction logs with this job' and then SQL 'Backup logs periodically' to 15 minutes and currently 'Retain log backups' to keep 2 days of log backups

But as the image level VM backs up every 24 hours is there any reason to keep 2 days of log backups?

I did think of using 'Until the corresponding image-level backup is deleted' however not sure if that would work with a forever forward as the backup just merges every so often rather than deleted?
jmmarton
Veeam Software
Posts: 2097
Liked: 310 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: SQL server forever forward incremental with transaction log backup

Post by jmmarton »

If you needed to do a point-in-time recovery for any reason that's older than the previous night's job, then having 2 days of transaction logs could be helpful. But unless you see the SQL guys needing to do that very often for test/dev purposes, it's probably overkill.

Joe
Post Reply

Who is online

Users browsing this forum: elenalad, Google [Bot] and 96 guests