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!