There's situation when my database(with memory optimized tables) has gone into 'Recovery Pending' state. I tried to put it into
emergency mode-->Single User Mode--> DBCC CHECKDB(<DBName>)--->set it online--->Multiuser mode.
But I am facing below error message while doing ONLINE mode.
Msg 5181, Level 16, State 5, Line 9 Could not restart database "DBName". Reverting to the previous status. Msg 5069, Level 16, State 1, Line 9 ALTER DATABASE statement failed. Msg 41316, Level 23, State 3, Line 3395 Restore operation failed for database 'DBName' with internal error code '0x0000000a'
I tried to check SQL error Log file and there's below message.
[ERROR] Database ID: [6] ''. Failed to load XTP checkpoint. Error code: 0x88000001. (d:\b\s2\sources\sql\ntdbms\hekaton\sqlhost\sqlmin\hkhostdb.cpp : 5288 - 'HkHostRecoverDatabaseHelper::ReportAndRaiseFailure')
And Rebuilding log file for Memory Optimized database is also not supported. Does anyone know familiar with such error?
User contributions licensed under CC BY-SA 3.0