all groups > sql server full text search > february 2004 >
You're in the

sql server full text search

group:

Rebuilding Catalog


Re: Rebuilding Catalog Hilary Cotter
2/25/2004 10:47:51 AM
sql server full text search:
A full population will not blow away an existing catalog. For instance once
you have done a full population you can then run another one and query at
the same time.

Consider this kb article for more information on building FTS catalogs on
one server and deploying them on another.

http://support.microsoft.com/default.aspx?scid=kb;en-us;240867

[quoted text, click to view]

Rebuilding Catalog Patrick
2/25/2004 1:41:02 PM
Hello

I have to rebuild a FT catalog with about 1.3mio records. Now the problem
is, when I make this on the system (it's a live system), it just takes too
much time, slows down the database and for beginning it clears all records.

Is there a way, to rebuild a new catalog to a different location, different
machine.. don't know, and the import this one or switch the catalogs or
something like that?

Thanks
Patrick

Re: Rebuilding Catalog Patrick
2/26/2004 9:13:33 PM
thank you for that news.... so for next time there is just the best way to
make the index on another db and copy it....

thnx


"Hilary Cotter" <hilaryk@att.net> schrieb im Newsbeitrag
news:%236sDKd7%23DHA.1452@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button