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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-12-28 : 10:26:46
|
| I'm new to full text catalogs and we have a vendor who's code utilizes them. The database server is SQL 2005 and I am noticing the following message in the SQL log every minute.Changing the status to MERGE for full-text catalog "ResearchCatalog" (5) in database "DBA_Test" (11). This is an informational message only. No user action is required.A SQL job is running the following command every minute.exec sp_fulltext_catalog 'ResearchCatalog', 'start_incremental'What is the typical frequency for running an incremental? Can the messages be suppressed?Thanks, Dave |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-28 : 22:46:11
|
| Hi,Use change tracking if possible. With change tracking it will automatically keep up to date. Otherwise run an full population every time you wish your catalog to reflect the current contents of your tables you are full-text indexing. You need a time stamp column on your tables for an incrementalpopulation to be run, otherwise a full population will be run. Incremental populations are frequently as lengthy as full populations.its me monty |
 |
|
|
|
|
|
Recommended frequency for fulltext incremental?