I have an SQL Server 2012 Enterprise database I’m trying to restore to SQL Server 2012 Web Edition instance. I’ve used
sys.dm_db_persisted_sku_features to find features to remove before a backup/restore down edition will work. I found partitioning and compression which I removed but
sys.dm_db_persisted_sku_features still tells me partitioning exists.
After looking closer I found several partition schemes and functions with names like
ifts_comp_fragment_partition_function_xxxxxxxx respectfully which are set to is_system=1. When trying to remove them I get the error “Cannot drop the partition scheme 'ifts_comp_fragment_data_space_ xxxxxxxx ', because it does not exist or you do not have permission.”
Apparently these are automatically created when full text indexes become large. I’ve removed all full text catalogs but the schemes and functions remain. Thinking they may not matter I tried the backup /restore. Within the restore error message was “Database '' cannot be started in this edition of SQL Server because it contains a partition function 'ifts_comp_fragment_partition_function_xxxxxxxx".
I’ve only found one solution here which forces the objects is_system property to 0 but it comes with a disclaimer that the solution probably isn’t supported by Microsoft. Assuming this would disqualify us for support in the future this is not an option for me.
Is there any other way around this problem? A way to remove these partitioning schemes and functions?