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 RAMCPU: 8 cores
Error Details:
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’.
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.
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 RAMCPU: 8 coresError Details: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’.Database: TestDB2Restore 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. Read More
