Collected transaction logs do not match any existing full da

Availability for the Always-On Enterprise

Collected transaction logs do not match any existing full da

Veeam Logoby beflo87 » Thu Dec 04, 2014 7:19 am

Hi,

we're havening some problems with our SQL Transaction log backup.
The first full backup ran without any problems, but the scheduled Transaction log backup Shows up the error "Collected transaction logs do not match any existing full database backup".
The database shows in the report as protected and could be restored to the date of the full backup.
Does anybody maybe knows what the problem could be?

Thanks for your help
beflo87
Novice
 
Posts: 3
Liked: never
Joined: Mon Nov 24, 2014 6:39 am

Re: Collected transaction logs do not match any existing ful

Veeam Logoby v.Eremin » Thu Dec 04, 2014 9:32 am

Can you tell us how both guest processing and SQL processing settings look like? Thanks.
v.Eremin
Veeam Software
 
Posts: 12873
Liked: 934 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Collected transaction logs do not match any existing ful

Veeam Logoby beflo87 » Thu Dec 04, 2014 12:20 pm

Guest processing is set to "require successful processing" and "process Transaction logs with this Job".
SQL processing is set to "Backup logs periodically: 30 minutes"

SQL Server ist Version 2008R2. With other SQL Server and the same Settings we have no Problem.

Thanks
beflo87
Novice
 
Posts: 3
Liked: never
Joined: Mon Nov 24, 2014 6:39 am

Re: Collected transaction logs do not match any existing ful

Veeam Logoby Vitaliy S. » Thu Dec 04, 2014 5:13 pm

Have you recently made any changes to the database you're backing up? State changes etc.?
Vitaliy S.
Veeam Software
 
Posts: 19383
Liked: 1088 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Collected transaction logs do not match any existing ful

Veeam Logoby AJ83 » Fri Dec 05, 2014 9:39 am

We are also having strange behaviour of VSS backup of SQL server in v8.
Since the upgrade this week, our SQL servers show SQL events login failure for the administrator account configured in Veeam to use. Why would it try to login on SQL? We have Transactionlog processing disabled, so it is set to perform copy only.
AJ83
Enthusiast
 
Posts: 55
Liked: 1 time
Joined: Tue Oct 06, 2009 2:32 pm

Re: Collected transaction logs do not match any existing ful

Veeam Logoby v.Eremin » Fri Dec 05, 2014 9:44 am

And Application Aware Processing is enabled, isn't it? If so, the situation looks expected, as some communication with VSS-aware application is still needed to freeze its activity prior to backup. Thanks.
v.Eremin
Veeam Software
 
Posts: 12873
Liked: 934 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Collected transaction logs do not match any existing ful

Veeam Logoby beflo87 » Mon Dec 08, 2014 7:39 am

Sorry for the late answer.
We made noch changes to the database after the last Full Backup.
beflo87
Novice
 
Posts: 3
Liked: never
Joined: Mon Nov 24, 2014 6:39 am

Re: Collected transaction logs do not match any existing ful

Veeam Logoby foggy » Mon Dec 08, 2014 10:25 am

I suggest contacting technical support as it is hard to say something without reviewing the logs.
foggy
Veeam Software
 
Posts: 14482
Liked: 1057 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Collected transaction logs do not match any existing ful

Veeam Logoby nholman » Sun Mar 15, 2015 10:50 pm

im seeing this with our availabilty group backup also. have had to open a support case it just makes no sense to me.
nholman
Enthusiast
 
Posts: 57
Liked: 5 times
Joined: Wed Nov 28, 2012 10:23 am
Full Name: Nick Holman

Re: Collected transaction logs do not match any existing ful

Veeam Logoby v.Eremin » Mon Mar 16, 2015 7:58 am

So, what was the result of support investigation? Was support engineer able to find the root cause of the experienced behaviour?
v.Eremin
Veeam Software
 
Posts: 12873
Liked: 934 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Collected transaction logs do not match any existing ful

Veeam Logoby blackforce » Thu Apr 30, 2015 8:01 am

We are also seeing this error. We have logged a case with Support
blackforce
Novice
 
Posts: 9
Liked: never
Joined: Wed Mar 24, 2010 10:08 am

Re: Collected transaction logs do not match any existing ful

Veeam Logoby v.Eremin » Thu Apr 30, 2015 8:47 am

Can you provide your case number here for convenience of future readers? Thanks.
v.Eremin
Veeam Software
 
Posts: 12873
Liked: 934 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Collected transaction logs do not match any existing ful

Veeam Logoby JaYaKaAzZ » Tue May 12, 2015 7:26 am

I have the same Problem on a customer Environment ... I watched the SQL Webinars 1 to 3 and they said you have to make more than 1 full backup before the Transaction Log Backup starts working... i made a full backup and a incremental backup and still have this error message... in the webinar they also said you have to disable all native and third Party Tools.. we done this too ...

Is there a Resolution ???
JaYaKaAzZ
Influencer
 
Posts: 24
Liked: 4 times
Joined: Mon Feb 03, 2014 8:01 am
Full Name: Artur Schneider

Re: Collected transaction logs do not match any existing ful

Veeam Logoby JaYaKaAzZ » Tue May 12, 2015 7:38 am

I just saw a strange behavior ... this error message appears still but i tried to make a Point in Time recovery and i was able to set Backup to each Log Event between full backup and incremental backup ....

p.s. dont know if the data is consistent when i recover to a SQL log Moment...but its possible to choose any time between full bkp and incremental
JaYaKaAzZ
Influencer
 
Posts: 24
Liked: 4 times
Joined: Mon Feb 03, 2014 8:01 am
Full Name: Artur Schneider

Re: Collected transaction logs do not match any existing ful

Veeam Logoby foggy » Tue May 12, 2015 11:51 am

Artur, I do not see any support case number in this thread to check for the resolution, so please contact support directly.
foggy
Veeam Software
 
Posts: 14482
Liked: 1057 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: macpt80, mcastelberg and 49 guests