Host-based backup of VMware vSphere VMs.
Post Reply
Neonium
Novice
Posts: 5
Liked: never
Joined: Apr 01, 2014 5:58 am
Contact:

SQL Transaction Log

Post by Neonium »

What you have to set the time a backup is the Transactionlogs be deleted when SQL servers?
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Transaction Log

Post by Vitaliy S. »

Hello,

If I got you correctly you want to truncate the transaction logs, right? In order to do this, you need to enable application aware image processing option in the job settings and make sure logs truncation is checked.

Thank you!
Neonium
Novice
Posts: 5
Liked: never
Joined: Apr 01, 2014 5:58 am
Contact:

Re: SQL Transaction Log

Post by Neonium »

Hello,
yes of course I mean truncate and not delete it. The Enable Application-Aware Image Processing option is active. The only thing that is set that he should ignore errors. Unfortunately, he performs under SQL not by the things. I got it now times changed to an error free backup.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Transaction Log

Post by Vitaliy S. »

Neonium wrote:Unfortunately, he performs under SQL not by the things.
Unfortunately, I do not understand what you're referring to here. Do you have some kind of errors when you enable this option?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Transaction Log

Post by veremin »

Unfortunately, he performs under SQL not by the things.
Are you saying that that you're trying to truncate SQL logs by both native SQL tools and backup application? Thanks.
Neonium
Novice
Posts: 5
Liked: never
Joined: Apr 01, 2014 5:58 am
Contact:

Re: SQL Transaction Log

Post by Neonium »

I mean he does it with MS Exchange, but not SQL. I have now built a SQL job for it with very large databases. It would be nice if Veeam makes for all databases.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Transaction Log

Post by foggy »

So, just to confirm, you have set Veeam B&R to truncate transaction logs (Truncate logs on successful backup only check box is selected), however logs are not truncated and you currently have to truncate them using native tools, right?
Neonium
Novice
Posts: 5
Liked: never
Joined: Apr 01, 2014 5:58 am
Contact:

Re: SQL Transaction Log

Post by Neonium »

Right. I have set the options. As it gets out of hand I make the Truncate SQL queries and add the one in a task.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Transaction Log

Post by foggy »

Do you have any warning/error messages in the job session log and/or any backup related messages in Windows Event Logs?
Neonium
Novice
Posts: 5
Liked: never
Joined: Apr 01, 2014 5:58 am
Contact:

Re: SQL Transaction Log

Post by Neonium »

that's the strange. Neither of Veeam get an error message nor can I find in the event log errors.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Transaction Log

Post by foggy »

Then I suggest contacting support for a closer look at your setup.
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 85 guests