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.
-
4It might be helpful to disclose what "error" messages you are seeing exactly otherwise people may just need to guess and thus not give you accurate feedback to your actual problem.– IT Thug NinjaMay 10, 2018 at 11:48
-
I can understand it but this is the only detail I got as of now due to limited access at my workplace.– Mr. KMay 10, 2018 at 13:09
1 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.