Please start any new threads on our new site at https://forums.sqlteam.com. 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 

SqlZ
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.

SqlZ
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 -