Restore x.bak file from SQL Server 2019 (version 15.00.2327) to SQL Server 2019 CU15 (15.00.4198) -> Error

Question

question

MB-1777 asked Apr 27, '22 AmeliaGu-msft commented May 2, '22

Restore x.bak file from SQL Server 2019 (version 15.00.2327) to SQL Server 2019 CU15 (15.00.4198) -> Error

Problem:
I have a Database backup file x.bak from a costumer SQL Server 2019 (version 15.00.2327)
I tried to restore this backup file with SSMS (SQL_Server_Management_Studio_SSMS_18_11_1)
to SQL Server 2019 (version 15.00.4198) , corresponds with KB5008996 Cumulative Update 15 for SQL Server 2019.

I get following error:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 15.00.2327. That version is incompatible with this server, which is running version 15.00.4198. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Question:
Which SQL Server 2019 product Version is behind (version 15.00.2327) ?
On website
https://sqlserverbuilds.blogspot.com/2019/01/sql-server-2019-versions.html
I couldn’t find a SQL Server 2019 Product for version 15.00.2327.

sql-server-general

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft · May 02 at 08:36 AM

Hi MB-1777,

How are things going? Were the answers helpful?
Please feel free to let us know if you have any other question. If the post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 ·

Answer 1 · 2022-04-27T15:24:52.327Z

TomPhillips-1744 answered Apr 27, '22

I cannot find any record of an official version 15.00.2327. Sometimes if a customer has a serious issue, MS Support will issue the customer a hotfix directly to a non-official version. But, I have never seen this kind of error due to a hotfix version and would not expect this kind of error. MS Support expects customers to update to the next CU when available to get the official supported version.

First, I would suggest you get the output from the customers server of SELECT @@VERSION.

Second, I would recommend they patch their server to a supported CU version.

https://support.microsoft.com/en-us/topic/kb4518398-sql-server-2019-build-versions-782ed548-1cd8-b5c3-a566-8b4f9e20293a

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-04-27T15:53:03.787Z

JingyangLi answered Apr 27, '22

Can you try to use Data-Tier Application (.bacpac file) to export the database from your client to see whether you can import the database over to your server?

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 3 · 2022-04-28T02:43:51.77Z

AmeliaGu-msft answered Apr 28, '22

Hi MB-1777,
Welcome to Microsoft Q&A.
In addition, it seems sql server thinks version 15.00.2327 is higher than version 15.00.4198.
So your customer may need to remove hotfix version 15.00.2327 first from Control panel ->Programs->Programs and Features->Installed Updates and then install CU 15 for SQL Server 2019.

Best Regards,
Amelia

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question