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 |
|
reganwick
Starting Member
4 Posts |
 Posted - 2007-07-24 : 11:17:51
|
| We have implemented a SQL Server 2005 Full Text Search solution with realtime updates to the catalog.Is it a best practice to rebuild the entire catalog periodically?I have been searching for best practices on this but without success. Any links to best practices for this sort of thing much appreciated.Thank you |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-24 : 14:43:13
|
| Don't have to, you can repopulate it periodically. |
 |
|
|
reganwick
Starting Member
4 Posts |
Posted - 2007-07-25 : 16:36:45
|
| ...and is there a need or advantage to repopulating the catalog? or are the realtime updates sufficient without any performance impact?thnx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-25 : 16:44:06
|
| I saw it happaned with real time update that catalog went out of date gradually. |
|
|
|
|
|
|
SQL Server 2005 FTS Catalog Rebuild