SQL truncate requested/good, but didn't happen

VMware specific discussions

SQL truncate requested/good, but didn't happen

Veeam Logoby pkelly_sts » Tue May 23, 2017 9:13 am

I've been having the well-known issue of SQL Logs not truncating due to lack of permissions. Having finally got the DBA to configure permissions as requested I'm now getting all green backups within Veeam, but he's reported (and I've verified myself) that the logs haven't actually truncated on all DBs, but have on some?

What could cause this scenario? I can see the veeam guest helper logs successfully claiming that all relevant (Full recovery mode) DBs have truncated as below (db2/db3 are simple mode):

22/05/2017 18:39:22 1512 Database tempdb: skipped transaction log truncation.
22/05/2017 18:39:22 1512 Database model: transation logs have been truncated.
22/05/2017 18:39:22 1512 Database msdb: skipped transaction log truncation.
22/05/2017 18:39:22 1512 Database <db1>: transation logs have been truncated.
22/05/2017 18:39:22 1512 Database <db2>: skipped transaction log truncation.
22/05/2017 18:39:22 1512 Database <db3>: skipped transaction log truncation.
22/05/2017 18:39:22 1512 Database <db4-didn't-truncate>: transation logs have been truncated.
22/05/2017 18:39:22 1512 Database <db5-didn't-truncate>: transation logs have been truncated.

DB1 did truncate as expected & the DBA was able to shrink this TL (it had grown to 40Gb over a period of time)
DB's 4 & 5 would expect to have a huge amount of white space now but don't.

Oh, & I just spotted a typo in your log generation "transation" rather than "transaction" :)
[New Sig: PLEASE get GFS tape support for incrementals!!!]
pkelly_sts
Expert
 
Posts: 504
Liked: 55 times
Joined: Thu Jun 13, 2013 10:08 am
Full Name: Paul Kelly

Re: SQL truncate requested/good, but didn't happen

Veeam Logoby foggy » Tue May 23, 2017 12:23 pm

Thanks, the typo will be fixed. As for the truncation issue, I'd let our tech staff review the logs. Do you see the corresponding "logs backed up" event in the Event Viewer logs on the SQL server, btw?
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL truncate requested/good, but didn't happen

Veeam Logoby pkelly_sts » Tue May 23, 2017 12:30 pm

Thanks for the pointer, yes, I can see an event 18265 "Log was backed up" for each of the DBs so again, it appears as though everything has worked, except the truncation itself didn't seem to occur for two DBs.

I wasn't sure about opening a case with support as it seems to me that Veeam has done its job: requested a snapshot, done a backup, released snapshot etc. so more of a SQL issue?
[New Sig: PLEASE get GFS tape support for incrementals!!!]
pkelly_sts
Expert
 
Posts: 504
Liked: 55 times
Joined: Thu Jun 13, 2013 10:08 am
Full Name: Paul Kelly

Re: SQL truncate requested/good, but didn't happen

Veeam Logoby foggy » Tue May 23, 2017 3:04 pm

Our engineers will be able to advise anyway.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 11 guests