Hi @Ivan Minchev ,
Welcome to Microsoft Q&A!
The restore activity may fail due to out-of-memory errors. It is recommended to configure a dedicated resource pool for In-Memory optimized database. In general, there would be a need of 3 * the size of the durable memory-optimized memory for the successful database restores operation. It is recommended test the backup and restore procedures in your environment.
Please refer to these links:
Restore and recovery of memory-optimized tables
Resolve Out Of Memory issues
In-Memory Optimized database backup and restore in SQL Server
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.