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

sql server full text search

group:

Text search on separate machine



Text search on separate machine Joan Shwake
2/25/2004 4:13:43 PM
sql server full text search: I assume the answer to my question is going to be NO, but I figured I'd ask
anyway....

Can you set the Full Text Search feature of SqlServer to run on a separate
machine? It seems to be stealing a lot of resources away from my DB, and
I'd rather put it on a machine without so much processor load....

Re: Text search on separate machine jt-kane NO[at]SPAM comcast.net
2/25/2004 5:36:10 PM
Joan,
What you're looking for is called "propgation" of the FT Catalogs to
other servers and while this is not directly supported by SQL Server,
you can still simulate this via the procedures in KB article 240867
(Q240867) "INF: How to Move, Copy, and Backup Full-Text Catalog
Folders and Files" at:

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

Also, if you're server is a multi-proc, there are methods to separate
the MSSearch processes from the MSSQLServer process, if the MSSearch
CPU process is affecting your SQL Server processing.

Regards,
John


[quoted text, click to view]
Re: Text search on separate machine Josh Knepfle
2/26/2004 3:54:58 PM
So, that machine has to have a license of SQL server on it, too, right?

[quoted text, click to view]

Re: Text search on separate machine jt-kane NO[at]SPAM comcast.net
2/26/2004 5:30:09 PM
Josh,
Yes, that is correct. KB article 240867 procedures require that SQL
Server and the MSSearch service be installed on all/both machines.

Regards,
John


[quoted text, click to view]
AddThis Social Bookmark Button