Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 928
  • Last Modified:

Unable to Remove FullText Catalog

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.

Thank you
0
wingkchan
Asked:
wingkchan
  • 3
  • 2
1 Solution
 
James MurrellProduct SpecialistCommented:
0
 
wingkchanAuthor Commented:
Hi cs97jim3

Have tried the MSDN suggested... it returned an error:
Error 7619:  Execution of a full-text operation failed.  The specified object cannot be found.  Specify the name of an existing object

As, the second forum suggested using command, but I think that does the same as right clicking and choosing delete... it also returns the same error messages as above...

Do you have any other ideas as to removing stubborn/orphan FullText Catalogs?
0
 
James MurrellProduct SpecialistCommented:
did you try back up your database. Then delete the rows.

Then try to create another catalog, and go back and edit the tables to move
them to the new catalog.
0
 
wingkchanAuthor Commented:
hi cs97jim3,

While I was still searching around for solution, a programmer delete the sysfulltextcatalogs table within the database, and the FullText Catalogs are gone for now.  However, i am not sure if the index fields within the tables and database are moved as well... but if there are other things to follow, we'll know about them at an later time.  

Thanks for the articles that you suggested!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now