Is there any different approach to restore a SQL Database backup having memory optimized tables as we know that there's additional filegroup present for holding In-Memory data.
The restore command showing error for not able to create xtp folder for memory optimized database while performing restore operation.
SQL Server 2016 – Database Backup and Restore Guide
restoresql serversql-server-2016
Related Question
- SQL Server – Backup and Restore Strategy
- SQL Server Error – In-Memory Optimized Error: Code Generation Directory Cannot Be Created
- SQL Server – Fastest Way to Roll Forward and Restore Multiple Files in Piecemeal Restore
- Sql-server – Backup and restore SQL server database with FILESTREAM filegroup
- Sql-server – SQL Server 2016 out of disk space
- Sql-server – Piecemeal Restore: Can you add new filegroups during the restore
- SQL Server – Restore Only Primary Filegroup and Bring Database Online
Best Answer
Note: to get the best help on this question, please include your actual RESTORE statement, and the specific error message that you're getting.
When using In-Memory OLTP, SQL Server has to create a new folder named "xtp" in the root of the default file location for the SQL Server instance. This folder contains the DLLs for compiled stored procedures and other in-memory objects. You can find more details about that here:
In-Memory OLTP files –what are they and how can I relocate them?
If you've changed the location for your data files, you may need to update SQL Server's access to the file system there:
Configure File System Permissions for Database Engine Access
As a test / workaround, you could manually create the "xtp" folder, and then try the restore again.