September 20, 2023 at 12:36 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:49 pm
dupe post, original here
https://www.sqlservercentral.com/forums/topic/how-to-restore-on-newer-version
September 21, 2023 at 6:36 pm
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 🙂
September 25, 2023 at 7:32 am
This was removed by the editor as SPAM
October 29, 2023 at 12:41 am
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