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.
jhyland
Lurker
 
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

Hi,

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

Thanks
PTide
Veeam Software
 
Posts: 3019
Liked: 246 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?
foggy
Veeam Software
 
Posts: 14724
Liked: 1076 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], Google [Bot], k00laid and 41 guests