Memory Optimized Database recovery

1

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?

sql
sql-server-2016
in-memory-database
database-restore
asked on Stack Overflow Jun 20, 2018 by Mr. K • edited Jun 20, 2018 by EzLo

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0