Discussions specific to the VMware vSphere hypervisor
Post Reply
Neonium
Novice
Posts: 5
Liked: never
Joined: Apr 01, 2014 5:58 am
Contact:

SQL Transaction Log

Post by Neonium » Apr 08, 2014 6:05 am

What you have to set the time a backup is the Transactionlogs be deleted when SQL servers?

Vitaliy S.
Product Manager
Posts: 22976
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Transaction Log

Post by Vitaliy S. » Apr 08, 2014 7:16 am

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 » Apr 08, 2014 8:17 am

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.
Product Manager
Posts: 22976
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Transaction Log

Post by Vitaliy S. » Apr 08, 2014 8:27 am

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: 16884
Liked: 1433 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Transaction Log

Post by veremin » Apr 08, 2014 8:33 am

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 » Apr 08, 2014 10:07 am

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: 18251
Liked: 1558 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Transaction Log

Post by foggy » Apr 08, 2014 10:13 am

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 » Apr 08, 2014 10:16 am

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: 18251
Liked: 1558 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Transaction Log

Post by foggy » Apr 08, 2014 10:24 am

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 » Apr 08, 2014 10:34 am

that's the strange. Neither of Veeam get an error message nor can I find in the event log errors.

foggy
Veeam Software
Posts: 18251
Liked: 1558 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Transaction Log

Post by foggy » Apr 08, 2014 10:35 am

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

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests