Re: Text search on separate machine

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Kane (jt-kane_at_comcast.net)
Date: 02/27/04


Date: 26 Feb 2004 17:30:09 -0800

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

"Josh Knepfle" <josh@sparkpeople.com> wrote in message news:<mFo%b.2018$Er4.1099@fe2.columbus.rr.com>...
> So, that machine has to have a license of SQL server on it, too, right?
>
> "John Kane" <jt-kane@comcast.net> wrote in message
> news:737946df.0402251736.67807a8c@posting.google.com...
> > 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
> >
> >
> > "Joan Shwake" <joanshwake@yahoo.com> wrote in message
> news:<XQ3%b.1504$Er4.252@fe2.columbus.rr.com>...
> > > 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....



Relevant Pages

  • Re: 2 Servers - 2 sets of results : issues after DB move
    ... you have to edit your noise word list. ... Then start up your mssearch again (at a command prompt issue a net start ... Looking for a book on SQL Server replication? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: C# is ignored on 2000 Server in mssearch
    ... It was my understanding that MSSearch was case-insensitive. ... Regards ... "John Kane" wrote: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Inserting new records into a large ADO table
    ... Regards, ... Vassiliev V. V. ... >> executes one SQL statement for each change in the CDS.Delta property. ... >> If you insert 1,000 rows the DSP will create and send to the server ...
    (borland.public.delphi.database.ado)
  • Re: changing data type or converting
    ... This is normally more a client side display thing, than a server side task. ... SQL does have the round() function: ... Regards ...
    (microsoft.public.sqlserver.programming)
  • Re: Full-text enabled greyed out
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... I have Windows Server 2003 for Small Business Server. ... The MSSearch service is running under the same account as the SQL ...
    (microsoft.public.sqlserver.fulltext)