Comprehensive data protection for all workloads
Post Reply
Posts: 23
Liked: never
Joined: Jul 29, 2013 2:13 am
Full Name: Scott

SQL Servers

Post by scottf99 » Nov 19, 2014 11:08 pm

Using V8.

I have a Veeam job running that backs up SQL Servers and truncate logs at 9pm daily. Out of the 10 Servers and 100 databases about 10 databases are set to Full Recovery and the other Simple. For those set to Full we have an SQL job that runs every 15mins between 8am and 5pm and does a Transaction Log backup. The Veeam job then runs at 9pm and truncates the logs. The login behind this is prior to using Veeam I was using SSMS SQL jobs to do backups and could restore a full SQL database with NORECOVERY and then roll in whatever Logs we needed to get a point in time.

It got a bit harder with Veeam V7. Had to restore the DB files to a temp server, do an SQL backup in SSMS and then restore with NORECOVERY then roll the logs then copy over to prod.

Whew, what a back story. So..... Can I now do all of this in Veeam V8? Full backup with truncate at 9pm daily and 15 min Tlog backups in business hours? Only need to keep 5 days of Tlogs and 14 Full backups (theory being any recovery older than 5 days will be a DR and a particular point in time is not required).


SVP, Product Management
Posts: 25122
Liked: 3685 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SQL Servers

Post by Gostev » Nov 20, 2014 12:18 am

Hi, Scott.

Yes, absolutely - v8 can do all of this for you.

Join the v8 launch webinar tomorrow to see it live! ... -here.html


Veeam Software
Posts: 18454
Liked: 1589 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Servers

Post by foggy » Nov 20, 2014 9:59 am 1 person likes this post

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], pudaltsov and 53 guests