Comprehensive data protection for all workloads
Post Reply
VanillaMastermind
Enthusiast
Posts: 37
Liked: 7 times
Joined: Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind
Contact:

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

Post by VanillaMastermind »

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?
Gostev
Chief Product Officer
Posts: 31814
Liked: 7302 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

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

Post by Gostev »

Any image-level backup at all should do (including incremental).
VanillaMastermind
Enthusiast
Posts: 37
Liked: 7 times
Joined: Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind
Contact:

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

Post by VanillaMastermind »

That was my understanding as well. If this continues to give me errors, I will submit a ticket. Thanks!
Post Reply

Who is online

Users browsing this forum: Egor Yakovlev, Semrush [Bot] and 75 guests