Restore backup in older SQL Server version

SQL Server Administration
1

Hello,
I need to restore a SQL Server 2019 backup file (.bak) on a server with SQL Server 2017 version, but I receive this error:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 15.00.2070. That version is incompatible with this server, which is running version 14.00.2027. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)

image
image1252×764 49.4 KB

I also cannot make scripts because the DB is too large to create CSV or TXT files (6 GB).

How can I solve this problem?

Thanks a lot.

Luigi

2

Have you tried SSIS package to copy or Export Data on the database?

image
image801×294 7.88 KB

1 Like
3

This I have to make on the server 2019, right?

May I can ask to make the backup "compatible" with 2017. Is it possible?

L.

4

You cannot restore a backup from a later version to an earlier version. The only option is to export the schema and structure and rebuild the database in the lower version.

1 Like