Upgrade to Veeam Availability Suite v8 failed with SQL-error

[Portvin]

When I tried to upgrade to Veeam Availability Suite v8 from version 7.0.0.871, the upgrade failed, and ruined the 7 installation.
I had to install v7 again, and restore from configuration backup.

The error message was:

Failed to execute SQL scripts for database VeeamBackup.
ExecuteNonQuery failed for Database 'VeeamBackup'



TomN

[foggy]

Tom, have you contacted technical support, as it is advised to do with all technical issues?

[Portvin]

Hi, yes I opened a case yesterday, and was told that this was a issue, I just wondered if anyone else have the same problem.
The first server I upgraded was succesfull, and is in production, the next one failed.


TomN

[foggy]

Could you please provide your case ID number? Thanks.

[Portvin]

00675448

[theeg]

We have the same error by updating the Veeam Backup & Replication 7.0 to 8

[bdoe]

Same thing happened to me. Hoping to hear about a patch or workaround soon. My case was 00675154.

[foggy]

As far as I know, support is able to assist with editing database to workaround the issue. The issue will be addressed further down the road.

[bdoe]

Support directed me to the following KB this morning: http://www.veeam.com/kb1953
I just finished rebooting the server and opened the console, which is a lot further than I got before.

[Portvin]

I followed the same KB http://www.veeam.com/kb1953 , and the upgrade succeded without problems.

TomN

[foggy]

Thank you both for confirmation, much appreciated.

[MLang.Systemwerker]

When I tried to upgrade to Veeam Availability Suite v8 from version 7.0.0.871, the upgrade failed, and ruined the 7 installation.
I had to install v7 again, and restore from configuration backup.

The error message was:

Failed to execute SQL scripts for database VeeamBackup.
ExecuteNonQuery failed for Database 'VeeamBackup'



TomN

I have the same error, it's already the second System now with this issue

I followed the same KB http://www.veeam.com/kb1953 , and the upgrade succeded without problems.

TomN

Unfortunately me not

- I did a bare metal recovery of the Veeam Backup Server now.
- I uninstalled the V7 Enterprise Manager, just to make the Veeam installation less complex.
- I followed the KB http://www.veeam.com/kb1953, 4 records were cleanup up by the SQL script.
- I tried V8 Upgrade once more, unfortunately same issue with ruined V7 Installation

What should I do now ? I don't like to do a new clean V8 Installation, particularly because of the filled up disk repositories and the tape media pools.

@Veeam Team:
Please work on your Setup routines soon, it's immpossible to ruin a Backup Server Setup, nearly every other Setup routines are able to do a tidy setup rollback

MfG
Manfred Lang

[foggy]

Manfred, please contact technical support to get assistance with this.

[MLang.Systemwerker]

Thank you foggy, I think you're right.

I tried to manually cleanup some DB entries with SQL Enterprise manager last 4 hours (e.g. rows in Tape.media_families without allocated mediums), but same result in ruined Veeam V7 Installation after V8 upgrade, I did a veeam backup Server bare metal recovery three times now

I'll contact technical Support next week. This week I've got no time, the V7 Installation works again now.

MfG,
Manfred Lang

[foggy]

Please provide the case ID once you open it, so we could track it for possible resolution in future.