September 20, 2023 at 12:34 pm
Hello all,
here we have a backup of a database from SQL 2000 (database version 539). For research purpose we need this database on our SQL 2022 (database version 957). The restore failed with following message:
System.Data.SqlClient.SqlError: The database was backed up on a server running database version 539. That version is incompatible with this server, which supports version 957. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)
How is it possible to bring this database to SQL 2022? Maybe restore on 2008 then backup and restore on 2016 then backup and restore on 2022, or something?
September 20, 2023 at 12:48 pm
dupe post, original here
https://www.sqlservercentral.com/forums/topic/how-to-restore-on-newer-version
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply