Add memory optimization set of files, start memory to optimize table, after restart the server database will appear challenged with
Logs an Error message: HkHostRecoverDatabaseHelper: : RestoreV2 () : the Database ID: [814] 'Qsoft. Failed to create XTP Database. Error code: 0 x88000001. (SQL \ NTDBMS \ hekaton \ sqlhost \ sqlmin \ hkhostdb CPP: 977 -' openExistingHkDatabase ')

Try to delete the memory optimization set of files and delete not to drop
Ask for help?

CodePudding user response:

is set to challenge status? After each question is how to deal with you?

CodePudding user response:

Delete the database and restore the backup

CodePudding user response:

Suggest to check and install the Latest SP patch corresponding SQL Server (Latest Service Pack).
Refer to https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server? View=SQL server -- ver15

CodePudding user response:

Suggest put memory tuning table into a regular tables, observe for a period of time to see if normal.

CodePudding user response:

Still the same, the key is I can't delete memory optimization file groups

CodePudding user response:

The official document:
The following limitations apply to a memory - optimized filegroup:
Once you use a memory - optimized filegroup, you can only remove it by dropping the database.

Refer to https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/the-memory-optimized-filegroup? View=SQL server -- ver15

CodePudding user response:

Can put the memory to optimize table into regular tables, which is equivalent to not use this feature, memory optimization file group will become empty, look to whether can also affect the normal use of the database.
If still be is a question, do you have a new database export - import data, finally replace the original database.