This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 83%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Hi,
In one of our legacy project we are using SQL Server 2017 database, and in this we need to restore backup (.bak) taken from SQL Server 2019 database. While database restore (taken from 2019) in SQL server 2017 we are getting incompatibility error. Can you please help us in resolving this error ?
Hi @Shyam Kumar ,
We haven't heard any response from you yet.
Is this issue solved now? If you have any questions, please feel free to share with us.
And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.
Thanks for your understanding!
Regards,
Lucy Chen
It is impossible to restore a backup from a higher SQL Server version to a lower (older) one, backups/databases are not backward compatible.
Any other way , we have to do this. Apart from from normal backup and restore method, is there any other way ?
Hi @Shyam Kumar,
Thanks for your information.
Here is an official document, it explains how to copy a database that's hosted on a later version of SQL Server to an earlier version of SQL Server.
Hope this can help you well.
If you have any concerns, please feel free to share with us.
Best regards,
Lucy Chen
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
https://docs.microsoft.com/en-us/answers/support/email-notifications
Hi @Shyam Kumar ,
We haven't heard any response from you yet.
Is this issue solved now? If you have any questions, please feel free to share with us.
And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.
Thanks for your understanding!
Regards,
Lucy Chen
The only way to restore this backup on that instance is to upgrade it to SQL 2019.
If this is not an option, you can try the Copy Database Wizard in Management Studio or try copy with help of a BACPAC.
Keep in mind the database may use syntax or features not available on SQL 2017.
You can't.
But you can try at source server , "export data-tier application" and then at the destination server, databases --> right click --> "Import data-tier application".