Articles in this section

See more

Unable to import/migrate or restore a SQL database in Plesk: The database was backed up on a server running version xxxx. That version is incompatible with this server

Avatar
Yulia Plokhotnikova
Updated
Follow
Plesk for Windows kb: technical ext: migrator ABT: Group A

Applicable to:

  • Plesk for Windows

Symptoms

  • Unable to migrate or restore a database from the backup:

    PLESK_ERROR: The database was backed up on a server running version 17.00.xx. That version is incompatible with this server, which is running version 12.00.xx. Either restore the database on a server that supports the backup or use a backup that is compatible with this server.

  • Default database server for MSSQL in Tools & Settings > Database Servers or in the service plan in Service Plans > plan_name > Hosting Parameters is older then the database version that is being transferred.

Cause

Microsoft SQL database cannot be restored on an SQL server with a lower version.

Resolution

If there is no installed MSSQLSERVER2017 (version that is being migrated) in Tools & Settings > Database Servers:

Install database server and migrate database
  1. Login to Plesk on the target server
  2. Install Microsoft SQL Server (SQL2017) at Tools & Settings > Updates & Upgrades
  3. Temporarily choose newly installed MSSQL server as default for MSSQL.
  4. Re-sync database files in Plesk > Tools & Settings > Migration & Transfer Manager > <migration_session> > Overview > re-sync next to the affected subscription > select Migrate database data (tables, rows, etc).
  5. Change default server for MSSQL back to initial one.
Install database server and restore database from the backup
  1. Login to Plesk 
  2. Install Microsoft SQL Server (SQL2017) at Tools & Settings > Updates & Upgrades
  3. Temporarily choose newly installed MSSQL server as default for MSSQL.
  4. Restore database from the backup 

If MSSQLSERVER2017 (version that is being migrated) is already installed in Tools & Settings > Database Servers:

Select newer version as default on a service plan level
  1. Login to Plesk on the target server

  2. Go to Service Plans > plan_name > Hosting Parameters and set newer MSSQL version as Default Database Server. MSSQL version should be the same or higher then on source server.

Additional information

ALTER DATABASE (Transact-SQL) Compatibility Level

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles