Comprehensive data protection for all workloads
Post Reply
adambrubaker
Lurker
Posts: 2
Liked: 1 time
Joined: Jul 31, 2015 11:26 am
Full Name: Adam Brubaker
Contact:

Feature Request: On demand SQL transaction log backups

Post by adambrubaker » Jul 31, 2015 1:00 pm 1 person likes this post

Hello

It would be nice if there was a way to run an on demand SQL transaction log backup job. Currently we our SQL transaction logs set to backup every hour. This works fine for us but occasionally someone will run a process or an application will go haywire and generate a ton of logs. If this happens and it brings down our application waiting for the next backup interval to expire ins't really a good option. Our current solution is to run a manual transaction log backup from SQL Management Studio. This works but it does not include this in the Veeam backup chain.

Thanks
-Adam

Dima P.
Product Manager
Posts: 10306
Liked: 836 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Feature Request: On demand SQL transaction log backups

Post by Dima P. » Aug 02, 2015 4:54 pm

Hello Adam,
Can you clarify how frequently you set to backup the transaction logs? Have you considered setting the shorter period? Thanks

veremin
Product Manager
Posts: 16691
Liked: 1393 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Feature Request: On demand SQL transaction log backups

Post by veremin » Aug 03, 2015 8:37 am

If you're willing to preserve particular state of SQL VM, haven't you thought about performing a quick backup for that VM after the said process?

adambrubaker
Lurker
Posts: 2
Liked: 1 time
Joined: Jul 31, 2015 11:26 am
Full Name: Adam Brubaker
Contact:

Re: Feature Request: On demand SQL transaction log backups

Post by adambrubaker » Aug 03, 2015 1:19 pm

Dima - We currently run our transaction logs every hour. I realize that we can set it to run more frequently but we really don't need to do that. With our previous backup solution we ran them every 6 hours and we were fine with that. Even if I set them to run every 15 minutes I could still have an issue and need to cleanup some transaction logs right away.

Vladimir - I had not thought about doing a quick backup. That would basically run an incremental, but I'm not sure if that process truncates transaction logs or not. Plus incrementals take a while to run (snapshot, mount the disc, backup, etc). Transaction logs are VERY fast. Ours currently run in less than an minute.

Thanks

Post Reply

Who is online

Users browsing this forum: Google [Bot], jtorres, nmdange, restore-helper, rpost and 31 guests