-
- 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
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?
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?
-
- 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
Frank, what is the Veeam B&R version?
-
- 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
Version 8. (.2030) fuly patched.
-
- Product Manager
- Posts: 6551
- Liked: 765 times
- Joined: May 19, 2015 1:46 pm
- Contact:
Re: Sql backup not truncating logs
Hi,
Do you have any messages in a Windows Application log? Seems like a permissions issue to me. Please check this article.
Thank you.
Do you have any messages in a Windows Application log? Seems like a permissions issue to me. Please check this article.
Thank you.
-
- 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
No permission issue as far as I can see. Will create a support ticket for a remote session
-
- 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
Yep, always worth to do if none of the "top of mind" guesses work.
Who is online
Users browsing this forum: chris.childerhose, david.tosoff, jsprinkleisg and 117 guests