Comprehensive data protection for all workloads
Post Reply
sixth
Enthusiast
Posts: 52
Liked: never
Joined: Feb 05, 2009 11:57 am
Contact:

Veeam SQL Transaction Log Shipping Issue

Post by sixth »

Hello All...

I just wanted to post a quick question to make sure my understanding of this Veeam feature is correct. We regards to Application Image Processing, is there a way/option to NOT truncate the log files of a SQL server during the Veeam backup process? The automatic truncation of log files is interfering with my transaction log file shipping. Is there anything veeam would recommend so this does not happen?

Thank you!

Jonathan

blakegrantham
Veeam Software
Posts: 12
Liked: never
Joined: Jun 01, 2010 2:07 pm
Full Name: Blake Grantham
Location: GA
Contact:

Re: Veeam SQL Transaction Log Shipping Issue

Post by blakegrantham »

Sure. In the Guest Processing page of setting up a backup job click the Advanced button->select your SQL server->Edit->and tick the 'Do not truncate logs' radio option.

Cheers

sixth
Enthusiast
Posts: 52
Liked: never
Joined: Feb 05, 2009 11:57 am
Contact:

Re: Veeam SQL Transaction Log Shipping Issue

Post by sixth »

Bingo....thank you!

GYeohAMAL
Lurker
Posts: 1
Liked: never
Joined: Jul 14, 2011 12:23 am
Contact:

Re: Veeam SQL Transaction Log Shipping Issue

Post by GYeohAMAL »

I've enabled this setting to stop truncates and my databases are still being truncated.

I'm using Veeam Backup & Replication 5.0.2.230 (32bit).

Does anyone have any suggestions ?

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

Re: Veeam SQL Transaction Log Shipping Issue

Post by Vitaliy S. »

This is the first time I hear this option doesn't work, I suggest contacting our support team for further investigation.

Gostev
SVP, Product Management
Posts: 28147
Liked: 4953 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Veeam SQL Transaction Log Shipping Issue

Post by Gostev »

I am guessing something else also backups SQL and truncates the logs.

Post Reply

Who is online

Users browsing this forum: beshka and 65 guests