Lost SQL database after 9.5 upgrade

[enricop]

I've just upgraded from Veeam B&R 9.0 upd 2 to 9.5 and I've messed up the database!

During upgrade I've been asked what SQL Server instance to use and confirmed the one automatically selected (named VEEAM) but I got an error because it was a SQL Server version 2005 and at least 2008 was required.

SO I clicked on the drop down list and saw an instance named VEEAMSQL2012 (I guess was installed by Veeam, surely I ddn't installed it), so I chose it.

Upgrade (apparently) went well, unfortunately after reboot Veeam is not "empty", none of my jobs, tapes, surebackups, virtual labs exists!

What is the best way to recover all Veeam "status"?
What would have been the right upgrade method?

BTW: I do have the automatic/defualt backup performed by "Backup Configuration Job" from this morning, would it be enough to restore it?

Thank you in advance for any hint.

Enrico

[Vitaliy S.]

HI Enrico,

Yes, you can either install a new Veeam B&R server and then import your previous configuration, or do in-place upgrade for the existing SQL Server 2005, and then point your Veeam backup server to that upgraded database. For more detailed instructions and guidance, feel free to contact our technical support team.

Thanks!

[Gostev]

And the good news is that you did not actually lose anything yet.

confirmed the one automatically selected (named VEEAM) but I got an error because it was a SQL Server version 2005 and at least 2008 was required.

This means all your configuration data sits in SQL 2005 database.

SO I clicked on the drop down list and saw an instance named VEEAMSQL2012 (I guess was installed by Veeam, surely I ddn't installed it), so I chose it.
Upgrade (apparently) went well, unfortunately after reboot Veeam is not "empty", none of my jobs, tapes, surebackups, virtual labs exists!

You picked a database that was empty, so unsurprisingly it remained empty after upgrade the only remaining step now is to import configuration backup created before the upgrade.

[enricop]

Thank you Vitaliy and Gostev for the reply, I already restored the full config&database from the last config backup (was up to date from the morning) and everything is back & fine.

Enrico