SQL logs not truncating

Discussions specific to Microsoft Hyper-V hypervisor

SQL logs not truncating

Veeam Logoby bplancic » Fri Jan 05, 2018 7:57 am

Hi,

I have one SQL server VM on Hyper-V cluster with few databases set up with full recovery mode. When backing up log files aren't getting backed up and truncated.

Application processing settings:

Image Image

Isn't this enough?

I tried setting up periodic log backup (VM backup once a day, log backup every 12 hours)
Image

but in that case I get an error

"Failed to prepare guest for SQL Server transaction log backup Details: Failed to connect to guest. Guest OS type: unknown
Transaction logs for the following databases were not backed up: "


According to Veeam KB https://www.veeam.com/kb2029 problem could be another job backing up SQL but there is no other job backing up that VM

Any ideas?

Regards,
bplancic
Influencer
 
Posts: 20
Liked: never
Joined: Tue Nov 26, 2013 11:37 am

Re: SQL logs not truncating

Veeam Logoby Vitaliy S. » Fri Jan 05, 2018 10:58 am

Hi,

Do you see any errors in the Windows Event log for that SQL Server when you run the backup job using the "truncate" option only? Are there any errors in the job session when logs truncation is enabled?

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 21169
Liked: 1259 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL logs not truncating

Veeam Logoby bplancic » Fri Jan 05, 2018 11:11 am

Hi Vitaly,

there are no errors whatsoever (not on SQL server, nor on Veeam server).

SQL server states that the databases were sucessfully backedup. SQL is 2014 SP2 (12.0.5546.0) and the OS is WS 2012 R2.

Regards,
bplancic
Influencer
 
Posts: 20
Liked: never
Joined: Tue Nov 26, 2013 11:37 am

Re: SQL logs not truncating

Veeam Logoby Vitaliy S. » Fri Jan 05, 2018 11:44 am

Ok, given that you're using local admin account in the VSS settings of the backup jobs, everything should be ok. Can you open a support case for our engineers to review the log files? Once you do this, please post your case ID in the topic (for future readers tracking).
Vitaliy S.
Veeam Software
 
Posts: 21169
Liked: 1259 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 6 guests