Tuesday, October 21, 2008

How to delete Full text catalog after restoring database!

When we are not copying the Full Text Catalog to new Server but we are restoring database to new server then there is only one choice to drop the full text catalog.
When we try to do that we will encounter following error

Error 7605: Full-text catalog has been lost after restoring database to new server

Error 7605: Full-text catalog 'ABCD' has been lost. Use sp_fulltext_catalog to rebuild and to repopulate this full-text catalog.

So the only solution to this is run following commands on order specified and then later we will be able to drop and recreate the catalog and start new population.

USE [dBName]
sp_fulltext_database 'disable'
Go
sp_fulltext_service 'clean_up'
Go
sp_fulltext_database 'enable'
Go


These commands will reset the entire system. Theoretically, you should be able to rebuild then.

No comments:

Post a Comment

Please do not spam!