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

Question

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.

Answer 1

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

Answer 2

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?

Answer 3

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.