Friday, July 13, 2012 1:29 AM
Is below one is a database specific or at instance level:
If I use above command, will it clean all the full text catalogs on all of the databases. Or it will clean only one database full text catalog where I execute this command.
Please let me know your thoughts if anyone uses this command earlier.
- Illiyaz Syed
- Moved by amber zhang Monday, July 16, 2012 1:33 AM (From:SQL Server Database Engine)
Friday, July 13, 2012 5:49 AM
cleans on all of the database/services and returns a null value
Searches for and removes the full-text catalog resources in the file system that do not have corresponding entries in sysfulltextcatalogs.
check this blog
Ramesh Babu Vavilla MCTS,MSBI
Saturday, July 14, 2012 11:00 PM
As per BOL,why the cleanup for fulltext means is as mentioned below (also note that it is in SQL server 2000 how ever still it is available 2005 + onwards with backward compatibility only)-
"There may be times when the metadata for a full-text catalog is changed (for example, when the full-text catalog is dropped or the database is dropped) while the Microsoft Search Service (MSSearch) is not running. The drop action changes the metadata related to the full-text catalogs but is unable to complete execution because the Microsoft Search Service is not running. This leads to inconsistency between the full-text metadata in SQL Server and the associated physical full-text catalog in the file system. This inconsistency can be corrected by using the clean_up action of sp_fulltext_service. Microsoft Search Service must be running".
Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and un-mark them if they provide no help.
- Marked As Answer by Iric WenModerator Tuesday, July 24, 2012 1:23 AM