Host-based backup of VMware vSphere VMs.
Post Reply
jluce
Enthusiast
Posts: 25
Liked: 3 times
Joined: Jan 14, 2015 2:23 am
Full Name: John Luce
Contact:

Backup snapshot failure with SQL error

Post by jluce »

We got a unique failure the first time a backup was tried that we had not seen before. Snapshot isolation transaction failed in database VeeamBackup because the object access by the statement has been modified by a DDL statement in another concurrent transaction since the start of this transaction. It is disallowed because metadara is not versioned. Basically Veeam created a temp table in a snapshot isolation level transaction and it got changed if I am reading this correctly? Subsequent attempts to backup the VM were successful. Is there something we should do to help this not to occur? We are running Veeam 9.5 Update 1.
Mike Resseler
Product Manager
Posts: 8191
Liked: 1322 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Backup snapshot failure with SQL error

Post by Mike Resseler »

John,

This is the first time I hear from this error. I think it is best that our engineers look at it so could you create a support call, post the case ID (and after that the follow-up) here?

Many thanks
Mike
MMSMicah
Lurker
Posts: 2
Liked: never
Joined: Mar 03, 2017 7:12 pm
Full Name: Micah MacDonald
Contact:

Re: Backup snapshot failure with SQL error

Post by MMSMicah »

We had this same error last night on one of our backup jobs. The automatic retry was successful and the rest of the jobs ran fine (12 jobs in total). We are on 9.5 update 1 also and this is the first time I have ever seen this.
Mike Resseler
Product Manager
Posts: 8191
Liked: 1322 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Backup snapshot failure with SQL error

Post by Mike Resseler »

Micah,

(Sorry for my late reply). It would be appreciated if you also can log a support call and post the support case ID and follow-up here.

Thanks
Mike
MMSMicah
Lurker
Posts: 2
Liked: never
Joined: Mar 03, 2017 7:12 pm
Full Name: Micah MacDonald
Contact:

Re: Backup snapshot failure with SQL error

Post by MMSMicah »

Sorry for the long delay folks. I just opened up a ticket with Veeam today so I will keep you posted.
Perseus83
Lurker
Posts: 1
Liked: never
Joined: Jan 13, 2015 2:26 pm
Full Name: Andreas Hagendorf
Contact:

Re: Backup snapshot failure with SQL error

Post by Perseus83 »

And then? Nothing to share after the error was fixed?

OMG I see this behavior at 90% of all technical questions that where asked.

Shame
foggy
Veeam Software
Posts: 21139
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup snapshot failure with SQL error

Post by foggy »

Hi Andreas, unfortunately, users do not often come back to update us on the results of the case investigation, that's why we always ask for the case ID when someone posts about technical issue - at least to be able to track the resolution in the internal case tracking system. I recommend you contacting support directly with this.
Post Reply

Who is online

Users browsing this forum: No registered users and 39 guests