SQL Server 2016 - backing up transaction l

Availability for the Always-On Enterprise

SQL Server 2016 - backing up transaction l

Veeam Logoby jhyland » Thu 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.
Posts: 1
Liked: never
Joined: Thu Sep 29, 2016 3:48 pm
Full Name: Jonathan Hyland

Re: SQL Server 2016 - backing up transaction l

Veeam Logoby PTide » Thu 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: 3403
Liked: 283 times
Joined: Tue May 19, 2015 1:46 pm

Re: SQL Server 2016 - backing up transaction l

Veeam Logoby foggy » Thu 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?
Veeam Software
Posts: 15600
Liked: 1162 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Return to Veeam Backup & Replication

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 1 guest