-
- Veteran
- Posts: 472
- Liked: 59 times
- Joined: Dec 14, 2015 9:42 pm
- Contact:
SQL Backup Chain Broken
Hi guys,
Since upgrading to Veeam B&R 9.5U4b our daily SQL backup chain is broken. On Sunday midnight we do a Full Backup using SQL to a folder on the SQL server, then each day at midnight a Differential is created, also to a folder on the SQL server. For some reason the Sunday night Full backup and the Monday Differential are no longer linked. When I look at the Backup Browser it mentions Veeam B&R every day now.
When I try to do a restore of the Full (NORESTORE) and then the Differential (RESTORE) it says that the Differential is not linked to the Full, specifically "This differential backup cannot be restored because the database has not been restored to the correct earlier state."
At the moment we can only restore the Full backups, not the Differentials, within SQL. I will open a case with Support, I am just hoping it is a simple fix that someone here can point out. Is this an issue with Application Awareness?
Since upgrading to Veeam B&R 9.5U4b our daily SQL backup chain is broken. On Sunday midnight we do a Full Backup using SQL to a folder on the SQL server, then each day at midnight a Differential is created, also to a folder on the SQL server. For some reason the Sunday night Full backup and the Monday Differential are no longer linked. When I look at the Backup Browser it mentions Veeam B&R every day now.
When I try to do a restore of the Full (NORESTORE) and then the Differential (RESTORE) it says that the Differential is not linked to the Full, specifically "This differential backup cannot be restored because the database has not been restored to the correct earlier state."
At the moment we can only restore the Full backups, not the Differentials, within SQL. I will open a case with Support, I am just hoping it is a simple fix that someone here can point out. Is this an issue with Application Awareness?
-
- Veteran
- Posts: 472
- Liked: 59 times
- Joined: Dec 14, 2015 9:42 pm
- Contact:
Re: SQL Backup Chain Broken
Sorry, it's 9.5U4a, not 9.5U4b.
-
- Veteran
- Posts: 472
- Liked: 59 times
- Joined: Dec 14, 2015 9:42 pm
- Contact:
Re: SQL Backup Chain Broken
A restore of a SQL database from VeeamBR gives "Specified cast is not valid. (SqlManagerUI)"
-
- Veteran
- Posts: 472
- Liked: 59 times
- Joined: Dec 14, 2015 9:42 pm
- Contact:
Re: SQL Backup Chain Broken
Case # 03756366
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL Backup Chain Broken
Hi Alex, are you backing up the same VM with Veeam B&R with the copy_only flag set?
-
- Veteran
- Posts: 472
- Liked: 59 times
- Joined: Dec 14, 2015 9:42 pm
- Contact:
-
- Veteran
- Posts: 472
- Liked: 59 times
- Joined: Dec 14, 2015 9:42 pm
- Contact:
Re: SQL Backup Chain Broken
The job was set with the default settings, we have only just discovered the issue after some data needed to be restored.
We have made the change to "Perform copy only" and changed to "Try application processing, but ignore failures"
I found this article enlightening:
https://helpcenter.veeam.com/docs/backu ... l?ver=95u4
We have made the change to "Perform copy only" and changed to "Try application processing, but ignore failures"
I found this article enlightening:
https://helpcenter.veeam.com/docs/backu ... l?ver=95u4
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL Backup Chain Broken
Yes, my guess is that this was the reason. Let's see if setting this option helps.AlexLeadingEdge wrote: ↑Sep 18, 2019 2:22 am The copy_only flag is not set. Would this explain why the Differentials don't appear to be linked to the Full backup in SQL?
-
- Veteran
- Posts: 472
- Liked: 59 times
- Joined: Dec 14, 2015 9:42 pm
- Contact:
Re: SQL Backup Chain Broken
Hi Foggy,
Yes, that has worked perfectly!
Yes, that has worked perfectly!
Who is online
Users browsing this forum: Semrush [Bot] and 11 guests