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