Hi SQL experts,
I encountered a problem where I could not remove the FullText Catalogs from a Database. I recenly migrated the SQL server from one machin to another. Both the new server and old server has the same database name, so I use DTS packages to migrate the tables from the old to the new.
Now, the developers notified me that some FullText Catalog could not be removed. When I choose "Delete", trying to delete the FullText Catalog, it will return an error:
Error 7619: Execution of a full-text operation failed. The specified object cannot be found. Specify the name of an existing object.
Another problem is, the catalogs are pointed to a location: F:\Microsoft SQL Server\MSSQL\FTDATA , but i noticed that directory doesn't contain any folders related to the catalog....
I wondering what could be the problem preventing the FullText Catalogs to be deleted. Is there anyway to delete them? Any suggestions would be greatly appreciated.