Comprehensive data protection for all workloads
Post Reply
driley
Influencer
Posts: 21
Liked: 2 times
Joined: Jan 04, 2017 4:49 pm
Full Name: Dennis Riley
Contact:

Veeam MS SQL backups and SQL Studio

Post by driley » Aug 10, 2018 1:37 pm

Hello,
If we use Full recovery model on a database, allow Veeam to backup and truncate logs, then a DBA makes an ad hoc backup using SQL Studio, how will Veeam handle this event?
Dennis

veremin
Product Manager
Posts: 17265
Liked: 1512 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Veeam MS SQL backups and SQL Studio

Post by veremin » Aug 10, 2018 4:07 pm

If you truncate logs using native SQL capabilities, there will be conflict during Veeam SQL log truncation job, as only one application must orchestrate log processing. Thanks.

DaveWatkins
Expert
Posts: 354
Liked: 94 times
Joined: Dec 13, 2015 11:33 pm
Contact:

Re: Veeam MS SQL backups and SQL Studio

Post by DaveWatkins » Aug 12, 2018 9:59 pm

The DBA could do with as long as they did a COPY_ONLY backup, that won't affect the transaction logs

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

Re: Veeam MS SQL backups and SQL Studio

Post by foggy » Aug 13, 2018 12:03 pm

That's correct.

Post Reply

Who is online

Users browsing this forum: DerOest, Google [Bot], Majestic-12 [Bot] and 64 guests