Database unsupported on upgrade to Backup&Replication V12

[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]

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

[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]

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

[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]

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

[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]

< v12 backups cannot be imported to PostgreSQL.

[backend]

... 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]

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

[ottl05]

I made a backup on the old server (Veeam 12.2) and want to migrate the configuration backup to a new server ( Veeam 12.3),
but "configuration restore not possible, backup was made with older versioon" and I can´t select postgresql as target.

So what should I do?