Lesson Learned #315: 'XTP' name is reserved for the files containing In-Memory OLTP data.

[Guest Jose_Manuel_Jurado]

Today, we worked on a service request that our customer got the following two error messages: The file name 'XTP' is reserved for the files containing In-Memory OLTP data or The filegroup name 'XTP' is reserved for the filegroup containing In-Memory OLTP data restoring a backup from OnPremises to Azure SQL Managed Instance. URL: T-SQL differences between SQL Server & Azure SQL Managed Instance - Azure SQL Managed Instance | Microsoft Learn

 

 

 

For the error: Msg 41927, Level 16, State 1, Line 1 - The file name 'XTP' is reserved for the files containing In-Memory OLTP data.

 

 

 

 

This above error means that we have a file in our Logical Names that is called XTP as Azure SQL Managed Instance is going to create an additional file for XTP automatically, there is not possible to have two with same name.

 

 

 

 

 

 

For the error message: Msg 41928, Level 16, State 1, Line 1 - The filegroup name 'XTP' is reserved for the filegroup containing In-Memory OLTP data.

 

 

 

 

In the similar situation that we have previously, if any of the filegroups of our database has XTP (except the memory optimized data) you are going to have this error message.

 

 

 

 

 

 

Enjoy!

 

Continue reading...