How to restore from old version

  • 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 wrote:

    dupe post, original here

    https://www.sqlservercentral.com/forums/topic/how-to-restore-on-newer-version%5B/quote%5D

    Yes, because when posting here I received "500 Bad Gateway" after very long waiting. Thats why I thougth that posting here is disabled because of old version. Sorry 🙂

     

  • This was removed by the editor as SPAM

  • Hi,

    You cannot upgrade directly to version 2022. Upgrading a SQL Server 2000 database to SQL Server 2022 directly is not supported. However, you can follow these steps to upgrade your database:

    1. Backup your SQL Server 2000 database: This is a crucial step to ensure you have a fallback option in case anything goes wrong during the upgrade process.

    2. Restore the backup on an intermediate version of SQL Server: SQL Server 2022 supports upgrades from SQL Server 2012 (11.x) SP4 or later. Therefore, you need to first restore your database on one of these versions.

    3. Upgrade the restored database to SQL Server 2022: Once your database is on a supported version, you can then upgrade it to SQL Server 2022.

    Please note that the compatibility level of a database acts as a bridge between old and new versions of SQL Server. Keeping a database at a lower compatibility level allows you to continue using it even after upgrading the SQL Server version. However, newer features won't be available within that database until you boost its compatibility level.

    Also, remember that cross-platform upgrade isn't supported. You can't upgrade a 32-bit instance of SQL Server to native 64-bit using SQL Server Setup. However, you can back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to a new instance of SQL Server (64-bit) if the databases aren't published in replication.

    Before upgrading, verify that the functionality you're currently using is supported in the edition to which you're moving. Also, ensure that your operating system is supported for SQL Server 2022.

    After you upgrade an instance of SQL Server to SQL Server 2022 (16.x), you can add features by using the SQL Server 2022 (16.x) Setup.

     

    =======================================================================

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply