Comprehensive data protection for all workloads
Post Reply
Posts: 1
Liked: never
Joined: Sep 29, 2016 3:48 pm
Full Name: Jonathan Hyland

SQL Server 2016 - backing up transaction l

Post by jhyland » Sep 29, 2016 3:57 pm

We are trying to backup the SQL Clusters with Veeam, but I’m not getting the option to restore back to a point-in-time using the transaction logs. We have the job backing up both servers, have application aware processing turned on, and have the option for the logs to backup periodically. Is there a switch, or setting, I’m missing here? Do I have to do any setup or maintenance jobs on the SQL Server? Currently no log files are being created. The full backup job has completed. The child job continues to run and should be getting transaction logs every 15 minutes. It doesn't look like anything is collected. We are new users, so we may be missing something very basic. Thanks for your help.

Product Manager
Posts: 5364
Liked: 473 times
Joined: May 19, 2015 1:46 pm

Re: SQL Server 2016 - backing up transaction l

Post by PTide » Sep 29, 2016 4:18 pm


MSSQL 2016 will be fully supported in Veeam Backup & Replication 9.5 which is to be released this fall.


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

Re: SQL Server 2016 - backing up transaction l

Post by foggy » Sep 29, 2016 4:43 pm

I'd expect the job complaining about inability to perform logs backup anyway. What do you see in the transaction logs backup job session? What do you see in Veeam Explorer for SQL Server? Are databases in question use full recovery mode? What kind of cluster it is?

Post Reply

Who is online

Users browsing this forum: thomas.lee and 24 guests