Comprehensive data protection for all workloads
Post Reply
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

Sql backup not truncating logs

Post by frankive »

Hi.
We have a brand new sql server 2012 R2 with Sql express 2014.
We do have a guest processing with the domain administrator to the sepcific server. The user also has full sysadmin role.
We do use log shipping every 15 min.
Everything seems fine and everything is green and shiny and the jobs says it truncates loag after image run.

But it doesn't.

The log remains the same size and is growing for each day.

What can cause this?
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sql backup not truncating logs

Post by foggy »

Frank, what is the Veeam B&R version?
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

Re: Sql backup not truncating logs

Post by frankive »

Version 8. (.2030) fuly patched.
PTide
Product Manager
Posts: 6551
Liked: 765 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Sql backup not truncating logs

Post by PTide »

Hi,

Do you have any messages in a Windows Application log? Seems like a permissions issue to me. Please check this article.

Thank you.
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

Re: Sql backup not truncating logs

Post by frankive »

No permission issue as far as I can see. Will create a support ticket for a remote session
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sql backup not truncating logs

Post by foggy »

Yep, always worth to do if none of the "top of mind" guesses work.
Post Reply

Who is online

Users browsing this forum: chris.childerhose, david.tosoff, jsprinkleisg and 117 guests