SQL-Log shipping

Availability for the Always-On Enterprise

SQL-Log shipping

Veeam Logoby larkrist » Fri Mar 03, 2017 12:00 pm

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.
larkrist
Novice
 
Posts: 6
Liked: never
Joined: Thu Feb 18, 2016 8:22 pm
Full Name: Lars Kristoffersen

Re: SQL-Log shipping

Veeam Logoby foggy » Fri Mar 03, 2017 3:45 pm

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.
foggy
Veeam Software
 
Posts: 15294
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Google [Bot], tdewin and 1 guest