Database restore to local

Question

Database restore to local

Rakesh T sasi 6

TITLE: Microsoft SQL Server Management Studio

Restore of database '******' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 16.00.0041. That version is incompatible with this server, which is running version 15.00.2000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.46521.71+(SMO-master-A)&LinkId=20476

BUTTONS:

OK

1 answer

Your answer

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

The backup you create was made on a SQL Server instance created with Microsoft SQL Server 2022 Community Technology Preview 1.0 (CTP 1.0) that is a beta version of SQL Server 2022 that was released on last December. You need to restore the backup on a SQL Server 2012 (beta) instance installed on the local computer.

You can also script your database schema and data using SSMS on the SQL Server 2022 instance and then run the script on the local SQL Server instance. Hopefully your database is not that big and the source database is not using SQL 2022 new features.

In addition, you can use SSIS or Export/Import wizard in SSMS to transfer the data from the SQL 2022 database to the SQL Server 2019 instance. You can also export the data from SQL 2022 database to flat files and use bulk insert or bcp to import these filat files into SQL Server 2019.

Rakesh T sasi 6 Reputation points

2022-05-24T05:26:13.123+00:00

Thanks for your reply. But the database is too large , I tried to generate the scripts, but I can't run that..
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-05-24T10:27:24.733+00:00

I updated my answer with a new paragraph giving you more options to downgrade your database.

Hope it helps.
Rakesh T sasi 6 Reputation points

2022-05-25T07:26:39.6+00:00

Okay thank you. Let me check that options..
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2022-06-03T03:57:20.223+00:00

Hi, @Rakesh T sasi if you find the above @Alberto Morillo reply helpful Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Regards
Geetha

Share via

Database restore to local

1 answer

Your answer