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
 General SQL Server Forums
 New to SQL Server Administration
 Full text index problem

Author  Topic 

TheSaintVII
Starting Member

1 Post

Posted - 2011-08-15 : 09:56:18
Hi all,

I've got a problem with a full text index that I can't fix.

On the search table for our intranet we have full text indexing enabled with changes set to be tracked automatically. This works fine for about a week and then it stops / gets stuck. To fix it I can manually apply the tracked changes. The index then works fine for another week before stopping again. This was working correctly for approx 10 months until about a month ago.

Has anyone seen this before or have any suggestions? We're using SQL Server 2008.

Thanks in advance,

MB
   

- Advertisement -