-
- Veteran
- Posts: 284
- Liked: 11 times
- Joined: Jan 06, 2011 8:33 am
- Contact:
[MERGED] : Error in SQL Transaction Log Backup
Hello ,
I have an Error when i want to backup the SQL Server Transaction Logs :
"Collected SQL Server transaction logs do not match any existing database backup"
What means this error ?
I have an Error when i want to backup the SQL Server Transaction Logs :
"Collected SQL Server transaction logs do not match any existing database backup"
What means this error ?
-
- Product Manager
- Posts: 20343
- Liked: 2281 times
- Joined: Oct 26, 2012 3:28 pm
- Full Name: Vladimir Eremin
- Contact:
Re: Collected transaction logs do not match any existing ful
Your post has been merged into existing discussion. Check the answers provided above and open a ticket, if further help is needed. Thanks.
-
- Veteran
- Posts: 284
- Liked: 11 times
- Joined: Jan 06, 2011 8:33 am
- Contact:
Re: Collected transaction logs do not match any existing ful
Ok ,
What is the Solution for this Error ?
In other Forums there is a Link to the SOLVED Answer . All of the Posts before has no solutions for this Error .
I find it very Strange that so many Customers has this Error but Veeam has no Solution for This ?
What is the Solution for this Error ?
In other Forums there is a Link to the SOLVED Answer . All of the Posts before has no solutions for this Error .
I find it very Strange that so many Customers has this Error but Veeam has no Solution for This ?
-
- Veeam Software
- Posts: 21124
- Liked: 2137 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Collected transaction logs do not match any existing ful
The reason is that this error can be a result of different issues and to effectively investigate what particular issue you're seeing, you should contact technical support and provide logs for review. Some of the issues that could cause this message were already addressed in the Veeam B&R v9, some have hotfixes, so I strongly recommend opening a case.
-
- Enthusiast
- Posts: 55
- Liked: 7 times
- Joined: Sep 24, 2014 7:44 am
- Full Name: Florian Raack
- Contact:
Re: Collected transaction logs do not match any existing ful
Hi Folks,
I have the same issue for one of `my customers SQL Servers. He opened a case (02184371) but it came to no result. He is running a SQL Server with 48 databases. 50% of db´s are in simple recovery mode, so Veeam should actually skip the transaction log processing and exclude these db´s. When we review the job report it seems to work in detail for every sindle DB as it is designed. Some are excluded and some are protected in detail like desired. But the job summary in total is failed because of a missing db full.
When I review the db settings in SQL server itself there is a time stamp set for the last full backup that Veeam did. So it seems that everything works absolutely like designed in this environment but the customer receives a worng report. There is no other maintainence task or apllication running against this SQL server.
I also double checked the Guest Helper logs on SQL server. There are no issues.
Does somebody has an idea why we receive a failed email report wehen everthing is fine?
I have the same issue for one of `my customers SQL Servers. He opened a case (02184371) but it came to no result. He is running a SQL Server with 48 databases. 50% of db´s are in simple recovery mode, so Veeam should actually skip the transaction log processing and exclude these db´s. When we review the job report it seems to work in detail for every sindle DB as it is designed. Some are excluded and some are protected in detail like desired. But the job summary in total is failed because of a missing db full.
When I review the db settings in SQL server itself there is a time stamp set for the last full backup that Veeam did. So it seems that everything works absolutely like designed in this environment but the customer receives a worng report. There is no other maintainence task or apllication running against this SQL server.
I also double checked the Guest Helper logs on SQL server. There are no issues.
Does somebody has an idea why we receive a failed email report wehen everthing is fine?
-
- Veeam Software
- Posts: 21124
- Liked: 2137 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Collected transaction logs do not match any existing ful
Florian, this doesn't look expected, so I've asked QA to check. You can also continue investigating with your support engineer, as far as I can see from the case notes, you didn't reply to his latest requests. Thanks.
-
- Enthusiast
- Posts: 55
- Liked: 7 times
- Joined: Sep 24, 2014 7:44 am
- Full Name: Florian Raack
- Contact:
Re: Collected transaction logs do not match any existing ful
Hi Foggy,
thanks for your reply. The customer stopped the communication because of illness. If you get feedback from QA I would be glad if you could let me know. Otherwise I will discuss with the customer to investigate a bit more detail with your tech support.
thanks for your reply. The customer stopped the communication because of illness. If you get feedback from QA I would be glad if you could let me know. Otherwise I will discuss with the customer to investigate a bit more detail with your tech support.
-
- Veeam Software
- Posts: 21124
- Liked: 2137 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Collected transaction logs do not match any existing ful
QA have checked but didn't see anything unexpected, the report contained valid information. So I'd recommend to continue working with support in case the issue still exists.
-
- Novice
- Posts: 6
- Liked: 4 times
- Joined: Jun 27, 2016 1:48 pm
- Full Name: Vadim
- Contact:
Re: Collected transaction logs do not match any existing full da
The same thing happens when you backup Principal and mirror SQL server OR two or more members of same SQL avaliability group.
1. Server A is backed up - logs are truncated
2. Server B is backed up - logs do not match anymore with state left after last incremental backup of server B. Logs are backed up and truncated with warning that they don’t match with las backup
3. Next cycle when server A is backed up - same thing happens as logs ware truncated by server B before, so they do not match anymore with last server A incremental backup
SOLUTION:
1. Set a different job and set only that 1 server (mirror or 1 of AG members) to execute SQL log backups
IF LIKE ME, in same availability group servers you have DB configured for Always On and others DB do not, so you have to backup all servers anyway you must :
2. On the Veeam backup and replication server exclude those DB that are configure for Always On to be backed up from all SQL servers except ONE server (step 1 in solution)
How to exclude:
https://www.veeam.com/kb2104
Hope that helps
1. Server A is backed up - logs are truncated
2. Server B is backed up - logs do not match anymore with state left after last incremental backup of server B. Logs are backed up and truncated with warning that they don’t match with las backup
3. Next cycle when server A is backed up - same thing happens as logs ware truncated by server B before, so they do not match anymore with last server A incremental backup
SOLUTION:
1. Set a different job and set only that 1 server (mirror or 1 of AG members) to execute SQL log backups
IF LIKE ME, in same availability group servers you have DB configured for Always On and others DB do not, so you have to backup all servers anyway you must :
2. On the Veeam backup and replication server exclude those DB that are configure for Always On to be backed up from all SQL servers except ONE server (step 1 in solution)
How to exclude:
https://www.veeam.com/kb2104
Hope that helps
Who is online
Users browsing this forum: Baidu [Spider], Google [Bot], Semrush [Bot] and 45 guests