How to restore on newer version

• mh

  Old Hand

  Points: 360

  More actions

  September 20, 2023 at 12:34 pm

  #4290331

  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?

• Ant-Green

  SSC Guru

  Points: 113514

  More actions

  September 20, 2023 at 12:48 pm

  #4290337

  dupe post, original here

  https://www.sqlservercentral.com/forums/topic/how-to-restore-on-newer-version