question

jdmelsa avatar image
jdmelsa asked

How do I remove Partition Schemes and Functions that got created by Full Text Index

I have a database that used to be on SQL Server 2005, but is now running on SQL Server 2012 (was migrated sometime ago). When the database was restored the Full Text indexes were updated. Today I noticed that there were 3 Partition Schemes and Functions that were created similar to this ifts_comp_fragment_data_space_32A8B93E and ifts_comp_fragment_partition_function_32A8B93E. I am trying to remove the old file/filegroup that the Full Text index was using. Unfortunately, I am not able to remove these Partition Schemas and Functions. Even after deleting the Full Text Indexes and Catalog. I am executing these commands as a user that has sysadmin privileges. If I try DROP PARTITION SCHEME [ifts_comp_fragment_data_space_32A8B93E] I get the error, Msg 15151, Level 16, State 1, Line 1 Cannot drop the partition scheme 'ifts_comp_fragment_data_space_32A8B93E', because it does not exist or you do not have permission. There are 3 pairs of Partition Schemas and Functions, and I can't remove any of them. I am hoping that there is a way to remove these, so I can remove the files/filegroup, without rebuilding the database. Thanks for any insight you can provide.
sql 2012partition
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.