sql server full text search: meaning of paused status -- sql server full text search

Re: meaning of paused status

muley
7/19/2005 10:32:08 PM

That helps a little. What I'm looking for is this: if the catalog is paused,
what is not running in the catalog? Are the indexes still useable, etc.

Can you point me to some documentation on the meaning of all the catalog
statuses? I've looked at all the microsoft documentation I can find and some
we searches, but no luck.

Thanks.

[quoted text, click to view]

Re: meaning of paused status

Hilary Cotter
7/20/2005 5:43:22 AM

You can still query when the indexing process is paused; you just won't be
able to index new content.

Regarding the status - does this help?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_7x15.asp

--
Hilary Cotter
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
[quoted text, click to view]

Re: meaning of paused status

muley
7/20/2005 7:50:06 AM

The link you gave me below is the only info I can find on the the statuses,
and it only lists what they are, not their meaning and what special
conditions are in effect when the catalog is in these states (like indexing
stopped, indexes not available, etc.).

[quoted text, click to view]

Re: meaning of paused status

muley
7/20/2005 8:08:10 AM

I have change-tracking background index update running. When I insert new
records into the table, the catalog status changes from "change tracking" to
"paused", back and forth several times, while the ~20k rows are being
inserted.

Are all the inserted records being indexed?

Thanks for the help.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server full text search group.