[SQL] After restore, log backups fail until ACTIVE FULL

Availability for the Always-On Enterprise

[SQL] After restore, log backups fail until ACTIVE FULL

Veeam Logoby VanillaMastermind » Fri Sep 16, 2016 2:49 pm

I am using app-aware processing to do SQL Server full and log backups. I can successfully restore a database in Veeam. However, after the restore is complete, log backups on that database fail. I expect this as the log chain has been broken. However, I expect them log backups to fail until the next Full database backup, which we have set to run nightly. I am still looking for patterns, but so far, I think the log backups fail until the next ACTIVE FULL backup within Veeam, which we have set to weekly.

Could I have something configured incorrectly? Since the nightly full backup in Veeam appears as a Full backup from a SQL Server perspective, shouldn't that be enough to reset the log chain?
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind

Re: [SQL] After restore, log backups fail until ACTIVE FULL

Veeam Logoby Gostev » Sat Sep 17, 2016 6:44 pm

Any image-level backup at all should do (including incremental).
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: [SQL] After restore, log backups fail until ACTIVE FULL

Veeam Logoby VanillaMastermind » Mon Sep 19, 2016 1:28 pm

That was my understanding as well. If this continues to give me errors, I will submit a ticket. Thanks!
VanillaMastermind
Enthusiast
 
Posts: 32
Liked: 4 times
Joined: Mon Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Exabot [Bot], Google [Bot] and 29 guests