Comprehensive data protection for all workloads
Post Reply
mack3457
Influencer
Posts: 11
Liked: 1 time
Joined: Sep 16, 2014 7:50 am
Full Name: Thomas Mack
Contact:

Database unsupported on upgrade to Backup&Replication V12

Post by mack3457 »

Hi,

just a short question: when upgrading from version 11 to version 12, we get the message:
Database server version VEEAM\VEEAMSQL2008R2 is not supported, version SQL Server 2012 (11.0.2100.60) or later is required.
I installed Postgres from the V12 iso file, but Postgres cannot be found by the version 11 veeam.backup.dbconfig.exe , so a migration to Postgres doesn't seem to be possible.

Is this a matter for a support request or can we have a simple or not so simple solution here directly?

Thanks.
Thomas Mack
Mildur
Product Manager
Posts: 10086
Liked: 2688 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by Mildur »

Hi Thomas

A V11 to V12 upgrade doesn't switch the configuration database type. You can switch to PostgreSQL after you have upgraded to V12. A configuration backup from V12 is required for the migration.
To be able to upgrade to V12, please migrate your configuration database to a supported MSSQL server (2012 or later). Then you can upgrade to V12.

Best,
Fabian
Product Management Analyst @ Veeam Software
mack3457
Influencer
Posts: 11
Liked: 1 time
Joined: Sep 16, 2014 7:50 am
Full Name: Thomas Mack
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by mack3457 »

Great, thanks.

How do I upgrade to MSSQL-Server 2012? The SQL server 2008 version was installed by Veeam on its own, so is there an option somewhere to upgrade the SQL server without buying a newer one from MS?

Thomas Mack
Mildur
Product Manager
Posts: 10086
Liked: 2688 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by Mildur »

Hi Thomas

The MSSQL Express server which Veeam has installed is like any other MSSQL Express server. You can follow Microsoft documentation for the upgrade. Check supported upgrade path here:
https://learn.microsoft.com/en-us/sql/d ... rsions-to-

I recommend to take a configuration backup before doing the MSSQL upgrade:
https://helpcenter.veeam.com/docs/backu ... ml?ver=120

Best,
Fabian
Product Management Analyst @ Veeam Software
mack3457
Influencer
Posts: 11
Liked: 1 time
Joined: Sep 16, 2014 7:50 am
Full Name: Thomas Mack
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by mack3457 »

In practice it didn't work out. SQL Server 2012 came out to be a separate installation instead of an upgrade and the 2012 server version wasn't found by veeam.

Removing SQL server 2012 didn't work out as well, as the deinstallation routine only offers to remove SQL server 2008R2 for some magic reason.

So, the easiest way seems to be a new installation of veeam together with another OS, as our Windows Server 2012 approaches EOL anyway.
Mildur
Product Manager
Posts: 10086
Liked: 2688 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by Mildur » 1 person likes this post

Hi Thomas

Thanks for the feedback.
If it's a new MSSQL instance, you could also have used the following user guide to migrate the database from the old MSSQL to the new MSSQL version:
https://helpcenter.veeam.com/docs/backu ... ml?ver=120

Best,
Fabian
Product Management Analyst @ Veeam Software
mack3457
Influencer
Posts: 11
Liked: 1 time
Joined: Sep 16, 2014 7:50 am
Full Name: Thomas Mack
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by mack3457 »

Hmm, restoring the configuration searches for a "Target Database" and it just offers "Microsoft SQL Server" (greyed out field), as it finds the old configuration being from MS SQL Server and "backup is older than v12".

So, no chance to import it to Postgres?
doktornotor
Expert
Posts: 107
Liked: 35 times
Joined: Mar 07, 2018 12:57 pm
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by doktornotor » 1 person likes this post

< v12 backups cannot be imported to PostgreSQL.
backend
Service Provider
Posts: 3
Liked: never
Joined: Sep 15, 2020 9:49 am
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by backend »

mack3457 wrote: Mar 13, 2023 9:13 am ... so a migration to Postgres doesn't seem to be possible.
If I recall correctly, I just made a v11 config backup, uninstalled v11 and MS SQL, installed v12 with PG, imported config backup.
doktornotor
Expert
Posts: 107
Liked: 35 times
Joined: Mar 07, 2018 12:57 pm
Contact:

Re: Database unsupported on upgrade to Backup&Replication V12

Post by doktornotor » 1 person likes this post

As noted multiple times, importing v11 backup to PostgreSQL is not possible.
Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot] and 72 guests