Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Full Text Issue

Author  Topic 

Yak Posting Veteran

69 Posts

Posted - 2005-04-12 : 12:59:12
Problem: DB has been restored from production to test SQL Server and full text queries don't return any records after the following has been done.

1. sp_fulltext_database 'disable'
2. sp_fulltext_database 'enable'
3. Removed Full Text indexing from the table from Enterprise Mgr.
4. sp_fulltext_catalog 'i_Memos_Cat', 'drop'
5. sp_fulltext_catalog 'i_Memos_Cat', 'create'
6. sp_fulltext_catalog 'i_Memos_Cat', 'start_full'
7. Recreate the FTI using Enterprise Mgr and specifying it to use the catalog i_Memos_Cat.

The indexes get created but don't seem to be populated even after I run the full population jobs.

Any suggestions would be greatly appreciated and sorry if this is a repeated question but searching for me came up short.

Thanks in advance.

Yak Posting Veteran

69 Posts

Posted - 2005-04-12 : 15:14:53
After many trials and tribulations I have figured out that there is an issue with this particular SQL Server because I can restore the db and then its FTI on another sql server without issues. Is there anyway to install FTI by itself without rebuilding the server? This is also a named instance.
Go to Top of Page

- Advertisement -