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

MB 1 Reputation point
2022-04-27T14:31:59.15+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,706 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2022-04-27T15:24:52.327+00:00

    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

    1 person found this answer helpful.
    0 comments
  2. Jingyang Li 5,891 Reputation points
    2022-04-27T15:53:03.787+00:00

    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?

    0 comments
  3. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2022-04-28T02:43:51.77+00:00

    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.

    0 comments