Comprehensive data protection for all workloads
Post Reply
raphael@schitz.net
Enthusiast
Posts: 71
Liked: 2 times
Joined: Jul 25, 2009 12:14 am
Contact:

Cannot use database because it was created wi

Post by raphael@schitz.net »

Hi guys,

I'd like to move a veeam backup server instance but when i install it else where and point it to the database, during the setup the Veeam Backup Service won't start and here is the error i got in the log :

Code: Select all

[DB|ERROR] Cannot use database [VeeamBackup], because it was created with later version of the product: product version 633, database version 638. (Veeam.Backup.DBCreator.CDatabaseException)
I guess this is because i installed the last patch on my existing setup (veeam_backup_6.5.0.144.patch3) and do the new install with an older build (veeam_backup_6.5.0.109_x64) ?

Thanks for your help.
Vitaliy S.
VP, Product Management
Posts: 27368
Liked: 2799 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Cannot use database because it was created wi

Post by Vitaliy S. »

To resolve that you can install Veeam B&R 6.5 build 109 with the default settings, upgrade it to 144 patch level and then re-attach the database from the previous/original installation to the new backup server. Should do the trick.
raphael@schitz.net
Enthusiast
Posts: 71
Liked: 2 times
Joined: Jul 25, 2009 12:14 am
Contact:

Re: Cannot use database because it was created wi

Post by raphael@schitz.net »

Thanks Vitaly but i would avoid creating a new database actually. What should append if i change the current_version row in the database and switch it back after setup finished?
Gostev
Chief Product Officer
Posts: 31793
Liked: 7295 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Cannot use database because it was created wi

Post by Gostev »

This may potentially create mess on many levels. Older build not understanding newer database schema and messing up configuration data, or patch 3 installation failing or messing up the actual database (if the patch involves updating database schema). This may also silently plant hidden issues into your configuration database... I would not recommend doing that, this is really dangerous in so many ways.

What is the problem creating new database temporarily? You can delete it immediately after you are done.
ecowgill
Veeam Software
Posts: 6
Liked: 1 time
Joined: Dec 01, 2011 9:51 pm
Full Name: Ed Cowgill
Location: Columbus, OH
Contact:

Re: Cannot use database because it was created wi

Post by ecowgill »

Hey Raphael,

We actually see this in support from time to time. You're correct that it has to do with having a higher patched version of Veeam and trying to migrate the database to a new location and then installing the base 6.5.0.109 version on top of it as the database version is a higher version. This behavior also happens if you uninstall a patched version of Veeam and reinstall in the same location as the database version isn't rolled back during uninstall. You can resolve this by running this query against your Veeam DB:

Code: Select all

update [version]
set current_version = '633'
where current_version = '638'
The only caveat to this is that once you make this change and successfully install the base 6.5.0.109 version you must immediately upgrade to 6.5.0.144 again at your new location (you cannot use this database with any other version other than 6.5.0.144). As Gostev said if you don't it is pretty dangerous. I have performed the above steps several dozen times for similar situations with no negative feedback. I encourage you to create a support ticket if you're not familiar with the SQL interface as support is trained to access and modify the database in scenarios like this.
raphael@schitz.net
Enthusiast
Posts: 71
Liked: 2 times
Joined: Jul 25, 2009 12:14 am
Contact:

Re: Cannot use database because it was created wi

Post by raphael@schitz.net »

Thanks Ed, i'll do that since i'm familiar enough with sql studio :)
Do you plan to release a 6.5.0.144 setup instead of path in order to correct that behavior?
Vitaliy S.
VP, Product Management
Posts: 27368
Liked: 2799 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Cannot use database because it was created wi

Post by Vitaliy S. »

raphael@schitz.net wrote:Do you plan to release a 6.5.0.144 setup instead of path in order to correct that behavior?
This is not planned.
raphael@schitz.net
Enthusiast
Posts: 71
Liked: 2 times
Joined: Jul 25, 2009 12:14 am
Contact:

Re: Cannot use database because it was created wi

Post by raphael@schitz.net »

ecowgill wrote:Hey Raphael,

We actually see this in support from time to time. You're correct that it has to do with having a higher patched version of Veeam and trying to migrate the database to a new location and then installing the base 6.5.0.109 version on top of it as the database version is a higher version. This behavior also happens if you uninstall a patched version of Veeam and reinstall in the same location as the database version isn't rolled back during uninstall. You can resolve this by running this query against your Veeam DB:

Code: Select all

update [version]
set current_version = '633'
where current_version = '638'
The only caveat to this is that once you make this change and successfully install the base 6.5.0.109 version you must immediately upgrade to 6.5.0.144 again at your new location (you cannot use this database with any other version other than 6.5.0.144). As Gostev said if you don't it is pretty dangerous. I have performed the above steps several dozen times for similar situations with no negative feedback. I encourage you to create a support ticket if you're not familiar with the SQL interface as support is trained to access and modify the database in scenarios like this.
it worked like a charm, thanks again!
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Cannot use database because it was created wi

Post by foggy »

Raphael, thanks for confirming that the proposed solution worked for you, much appreciated.
Post Reply

Who is online

Users browsing this forum: d.artzen, mortenr, Semrush [Bot], Steve-nIP and 84 guests