Re: Update to SP4 causes starnge Server behavior
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Mon, 9 Jul 2007 07:38:12 -0400
Have your catalogs finished building? IIRC Service Pack 4 involves a
rebuilding of your full-text catalogs.
From:
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm#_full-text_catalogs_will_be_rebuilt_after_setup_completes
All full-text catalogs are rebuilt as part of the installation of SP4 when
upgrading from SP2 or earlier. The rebuild is automatic and
resource-intensive. Queries against full-text catalogs may return partial
results or no results until the rebuild process is complete. After SP4 is
installed, the system event logs contain messages stating that the catalogs
were corrupt, of an older version, and had to be rebuilt.
For information , see the Knowledge Base article 327217, which also
discusses possible workarounds for keeping full-text search available during
the rebuild process and to avoid an automatic rebuild.
Also the algorithim changed between the two service packs. You might want to
set remote timeout to a larger value to see if this helps.
sp_configure 'remote query timeout (s)' ,10000
reconfigure with override
--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Josef Huber" <JosefHuber@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:15627583-35AB-42BA-BE7D-AF4AB8C9EFB9@xxxxxxxxxxxxxxxx
I tried all of that, but the only way to get the fts running, is to restart
the server.
"Mohit K. Gupta" wrote:
Did you try rebuilding the index or re-doing the FTS Catalog? And next
time
FTS mucks up maybe try just restarting the service? Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
.
- Prev by Date: RE: Too many full-text columns or the full-text query is too compl
- Next by Date: Re: unexpected behavior with certain words "i"
- Previous by thread: RE: Too many full-text columns or the full-text query is too compl
- Next by thread: Re: unexpected behavior with certain words "i"
- Index(es):
Relevant Pages
|
