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