sql sp3 failed to upgrade search service on passive node

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newbie - 14 Sep 2006 16:47 GMT

Env: sql 2k sp3 Ent. ed running on win2k3 active/passive cluster

When SQL SP3 was applied on the cluster it failed to upgrade ms search on
the passive node
causing ms search on the two nodes to go out of sync.

Because of this the catalog created on the active node isn't usable on the
passive after a failover.

Found this in the log.
Setup is installing the Microsoft Full-Text Search Engine ...
"...\sql_sp3\x86\FullText\MSSearch\Search\SearchStp.exe" /s /a:SQLServer
Process Exit Code: (2) The system cannot find the file specified.

How can this be fixed? as simple as running searchstp.exe on the passive
node?

Thanks in advance,

Gigel

Reply to this Message

Hilary Cotter - 14 Sep 2006 17:01 GMT

Unfortunately I don't believe so. Can you try to apply the service pack
again from the problem node?

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

> Env: sql 2k sp3 Ent. ed running on win2k3 active/passive cluster
>
[quoted text clipped - 16 lines]
>
> Gigel

Reply to this Message