Veeam MS SQL backups and SQL Studio

Availability for the Always-On Enterprise

Veeam MS SQL backups and SQL Studio

Veeam Logoby driley » Fri 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
driley
Novice
 
Posts: 4
Liked: 1 time
Joined: Wed Jan 04, 2017 4:49 pm
Full Name: Dennis Riley

Re: Veeam MS SQL backups and SQL Studio

Veeam Logoby v.Eremin » Fri 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.
v.Eremin
Veeam Software
 
Posts: 14966
Liked: 1122 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Veeam MS SQL backups and SQL Studio

Veeam Logoby DaveWatkins » Sun 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
DaveWatkins
Expert
 
Posts: 311
Liked: 82 times
Joined: Sun Dec 13, 2015 11:33 pm

Re: Veeam MS SQL backups and SQL Studio

Veeam Logoby foggy » Mon Aug 13, 2018 12:03 pm

That's correct.
foggy
Veeam Software
 
Posts: 16513
Liked: 1324 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: bdufour, LBegnaud and 66 guests