Comprehensive data protection for all workloads
Post Reply
larkrist
Novice
Posts: 8
Liked: 1 time
Joined: Feb 18, 2016 8:22 pm
Full Name: Lars Kristoffersen
Contact:

SQL-Log shipping

Post by larkrist »

1. Customer is using Veeam for instant-backup down to 15 min for his SQL-server, this is working excelent. this truncates the SQL-Logs
2. Actual question is that he wants log shipping to another SQL-server so he can create reports on that server, how can this be solved when the logs are already truncated?
3. Is question 2 possible or any tips how to make this work.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL-Log shipping

Post by foggy »

larkrist wrote:2. Actual question is that he wants log shipping to another SQL-server so he can create reports on that server, how can this be solved when the logs are already truncated?
Lars, if I'm getting you right, you want to be able to replay logs on another SQL Server, right? For that you need to disable logs processing in Veeam B&R and use native tools (SQL Management Studio) to backup logs.
dfrederiksen
Lurker
Posts: 2
Liked: never
Joined: Aug 29, 2018 5:15 pm
Full Name: David Frederiksen
Contact:

Re: SQL-Log shipping

Post by dfrederiksen »

Has anyone revisited this and found other solutions? We would like to maintain the backups in Veeam but also not break sync in a log shipping arrangement.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL-Log shipping

Post by foggy »

As mentioned above, you need to configure Veeam B&R to not touch transaction logs during backup. For that, select the 'Perform copy only' option in the job settings.
Post Reply

Who is online

Users browsing this forum: ante_704 and 215 guests