SQL Server In-Memory Databases in SUSPECT Mode After Update to SQL Server 2019 (RTM-CU27-GDR) (KB504

Hello everyone,

Last night, we updated our SQL Server to version SQL Server 2019 (RTM-CU27-GDR) (KB5040948). Unfortunately, after restarting the system, two of our In-Memory databases went into the SUSPECT state and did not come online. Below are the server specifications and error details:

Server Specifications:

• Memory: 48 GB RAM
• CPU: 8 cores

Error Details:

1. Database: TestDB1

   • [ERROR] openExistingHkDatabase(): HkHostRecoverDatabaseHelper::RestoreV2(): Database ID: [19] 'TestDB1'. Failed to create XTP database. Error code: 0x88000001.
   • [ERROR] HkHostRecoverDatabaseHelper::ReportAndRaiseFailure(): Database ID: [19] 'TestDB1'. Failed to load XTP checkpoint. Error code: 0x88000001.
   • Restore operation failed for database 'TestDB1' with internal error code '0x88000001'.

2. Database: TestDB2

   • Restore operation failed for database 'TestDB2' with internal error code '0x88000001'.

We checked the SQL Server log files and found the above errors indicating problems with creating the XTP database and loading the XTP checkpoint. The databases are currently in the SUSPECT state.