Re: 'update index in background' not running.
- From: "John Kane" <jt-kane@xxxxxxxxxxx>
- Date: Thu, 27 Oct 2005 23:03:32 -0700
John,
First you should review the server's "Microsoft Search" and MssCi source
events (informational, warnings & errors), as it is only in the Application
event log that SQL Server 2000 FT Indexing success & failures are recorded.
Secondly, could you execute the following SQL code and post the output?
use <your_database_name>
go
SELECT OBJECTPROPERTY
(object_id('<table_name>'),'TableHasActiveFulltextIndex')
SELECT OBJECTPROPERTY
(object_id('<table_name>'),'TableFullTextBackgroundUpdateIndexOn')
SELECT OBJECTPROPERTY
(object_id('<table_name>'),'TableFullTextChangeTrackingOn')
go
select FulltextCatalogProperty('<FT_Catalog>', 'UniqueKeyCount')
select FullTextCatalogProperty('<FT_Catalog>', 'itemcount')
select FullTextCatalogProperty('<FT_Catalog>', 'indexsize')
Have you or anyone else changed the MSSQLServer service startup account &/or
password via Win2K's components service? Also, does the SQL Server login
BUILTIN\Administrator exist on this server with all of it's normal defaults:
master database, SysAdmin rights? Depending upon your answers, you should
review the following KB articles:
317746 (Q317746) PRB: SQL Server Full-Text Search Does Not Populate Catalogs
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
277549 (Q277549) PRB: Unable to Build Full-Text Catalog After You Modify
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
If the BUILTIN\Administrator account was removed for security reasons, you
can use the following SQL code to get FTS to work without it:
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"John Mott" <johnmott59@xxxxxxxxxxx> wrote in message
news:eHI51vy2FHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
> this is a new windows 2003 server/sql server 2000 set up (2-3 days old).
> full text is set up and working and definetely added data, andi have
> update
> index in background set.
>
> It seems to have worked for a while, then stopped. The application event
> log
> records events for Microsoft Search as 'Search service has started',
> 'Search
> service has loaded project ...' and 'indexer started successfully for
> project..' from yesterday afternoon, about the time that it stopped
> adding
> articles.
>
> There is only one catalog and one table with two fields that are indexed.
>
> since there is data in there it seems to have stopped in the last day or
> so.
> the system is lightly loaded, nothign else going on, and i can see
> mssearch.exe in the task list.
>
> where can i look to see why its not loading?
>
> thanks,
>
> john
>
>
>
.
- Follow-Ups:
- Re: 'update index in background' not running.
- From: John Mott
- Re: 'update index in background' not running.
- References:
- 'update index in background' not running.
- From: John Mott
- 'update index in background' not running.
- Prev by Date: Re: Batch Size
- Next by Date: Re: 'update index in background' not running.
- Previous by thread: 'update index in background' not running.
- Next by thread: Re: 'update index in background' not running.
- Index(es):
Relevant Pages
|
