Re: Misterious disabling of table FTS
- From: "Francisco" <franciscousenet@xxxxxxxxx>
- Date: Thu, 11 Jan 2007 12:19:57 -0000
Oops,
Just to add this was on SQL 2005 sp1
Thanks.
"Francisco" <franciscousenet@xxxxxxxxx> wrote in message
news:%23x$Xz7WNHHA.2232@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,
Today two tables in the same database ( which are the only ones with FTS
in that database) had FTS disabled. I know for sure that yesterday both
of them were enabled and working and nothing is showing in the logs about
any change to the status ( apart from the normal automatic PAUSE and
RESUME of indexing for the daily backup. ).
When I manually re-enabled each table the same message was created in the
logs:
"Changing the status to MERGE for the full-text catalog ".
Although everything is working now I am trying to track what could of
caused this.
Apart for purposely setting the table FTS disabled manually, what other
event could have caused the table's FTS become disabled?
Other databases in the same server had FTS on tables that weren't
affected.
Thanks for the help.
Francisco
.
- References:
- Misterious disabling of table FTS
- From: Francisco
- Misterious disabling of table FTS
- Prev by Date: Misterious disabling of table FTS
- Next by Date: Full text search with SQL2005 X64 version
- Previous by thread: Misterious disabling of table FTS
- Next by thread: Full text search with SQL2005 X64 version
- Index(es):
Relevant Pages
|
Loading
