SQL Server Error Msg 12107 – Adding a MEMORY_OPTIMIZED_DATA filegroup is not supported for databases that have one or more publications that use sync_method ‘database snapshot’ or ‘database snapshot character’.

In this blog post, let’s learn about the error message “12107 – Adding a MEMORY_OPTIMIZED_DATA filegroup is not supported for databases that have one or more publications that use sync_method ‘database snapshot’ or ‘database snapshot character’.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

12107 – Adding a MEMORY_OPTIMIZED_DATA filegroup is not supported for databases that have one or more publications that use sync_method ‘database snapshot’ or ‘database snapshot character’.

Reason for the Error

To be update soon…

Solution

To be update soon…