Skip to content
  • Solutions
    By Role
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    By Infrastructure
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
  • Product
    • Plesk Features
    • Plesk Editions
    • What’s new
    • Pricing
    • Roadmap
    • Lifecycle Policy
    • Extensions Catalogue
  • Pricing
  • Extensions
    Featured Extensions
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    Bundles and packs:
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack

    See all Extensions

  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
Plesk 360 login
Free Trial

Knowledge Base

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

 
backupbackup restore migrationdatabasedatabase servergo

Symptoms

  • Unable to import/migrate/restore a SQL database in Plesk, the following error message is shown:

    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 than the database version that is being transferred.

Cause

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

Resolution

  1. Log in to Plesk (on the target server, in case of migration).

  2. Go to Tools & Settings > Database Servers, and check if there is a server with .MSSQLSERVER2017 Host name .

    • 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. Log in 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.
    • If there is no installed MSSQLSERVER2017 (version that is being migrated) in Tools & Settings > Database Servers, use one of the following solutions depending on the situation:

    Migration

    1. Log in to Plesk on the target server.
    2. Install Microsoft SQL Server (SQL2017) at Tools & Settings > Updates & Upgrades
    3. Go to Tools & Settings > Database Servers, select MSSQLSERVER2017 > Settings > check Use this server as default for MS SQL.
    4. Re-sync database files under 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.

    Database backup restoration

    1. Log in to Plesk.
    2. Install Microsoft SQL Server (SQL2017) at Tools & Settings > Updates & Upgrades
    3. Go to Tools & Settings > Database Servers, select .MSSQLSERVER2017 > Settings > check Use this server as default for MS SQL.
    4. Restore database from the backup.

Additional information

ALTER DATABASE (Transact-SQL) Compatibility Level

Tweet
Share
Share
Email
0 Shares
Read the full article
Related Posts

How to Host a Go App on Plesk

Read More »

You Are Always Safe When You Have an Up-To-Date Plesk Backup

Read More »

Plesk with Centralized Database and Network File System

Read More »
Knowledge Base

How to add a new instance of existing MS SQL Server to Plesk

Read More »

How to add an already installed Microsoft SQL server in Plesk

Read More »

How to retain databases during Plesk migration when both servers share same remote database server?

Read More »

Import/export of a remote MS SQL Server database fail in Plesk: Unable to connect to the network share Unable to open network connection: A specified logon session does not exist. It may already have been terminated

Read More »

Hosting Wiki

  • Django
  • Server Redundancy
  • Google Cloud CDN
  • PostgreSQL
  • AMP
  • Bare Metal Server
  • Backup
  • MySQL
  • Oracle VM Server
  • Server Virtualization Software
  • Windows Server
  • MSSQL
  • MongoDB
  • SQL
  • Hosting Control Panel
  • Plesk
  • SQL database
  • NoSQL Database
  • Web Server
  • DNS Server
  • Colocation Hosting
  • Reseller Hosting
  • Cloud Hosting
  • VPS Hosting
  • Dedicated Hosting
  • Shared Hosting
  • Free Hosting
  • Managed Hosting
X-twitter Linkedin Youtube Reddit Github
  • Product
  • Login
  • Pricing
  • Editions
  • For Partners
  • Partner Program
  • Contributor Program
  • Affiliate Program
  • Plesk University
  • Company
  • Blog
  • Careers
  • Events
  • About Plesk
  • Our Brand
  • Resources
  • User and Admin guides
  • Help Center
  • Migrate to Plesk
  • Contact Us
  • Hosting Wiki
  • Forum
  • Legal
  • Legal
  • Privacy Policy
  • Imprint

© 2025 WebPros International GmbH

Part of the WebPros®  Family