-
- Enthusiast
- Posts: 25
- Liked: 3 times
- Joined: Jan 14, 2015 2:23 am
- Full Name: John Luce
- Contact:
Backup snapshot failure with SQL error
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.
-
- 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
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
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
-
- Lurker
- Posts: 2
- Liked: never
- Joined: Mar 03, 2017 7:12 pm
- Full Name: Micah MacDonald
- Contact:
Re: Backup snapshot failure with SQL error
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.
-
- 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
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
(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
-
- Lurker
- Posts: 2
- Liked: never
- Joined: Mar 03, 2017 7:12 pm
- Full Name: Micah MacDonald
- Contact:
Re: Backup snapshot failure with SQL error
Sorry for the long delay folks. I just opened up a ticket with Veeam today so I will keep you posted.
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Jan 13, 2015 2:26 pm
- Full Name: Andreas Hagendorf
- Contact:
Re: Backup snapshot failure with SQL error
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
OMG I see this behavior at 90% of all technical questions that where asked.
Shame
-
- 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
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.
Who is online
Users browsing this forum: No registered users and 66 guests