Showing posts with label fulltext. Show all posts
Showing posts with label fulltext. Show all posts

Friday, March 30, 2012

How to disabel the Microsoft Search Service

Hi everybody,

I work with SQL Server 2000 SP2 in an Active/active Cluster.
Two days ago, one the sql server fulltext resource of one node just failed suddenly.
Now I am realizing that Search Engine Utility has not been used by any of my databases, so I would like do disable this service...
Does anybody know how can I get rid of the Microsoft Search Service.
I don't need this service active!
In Service Manager the Microsoft Search is in an unkown state.
In cluster Administrator the sql server full text resource is in a failed state.
Do I need to delete the full text resource or is there any other way to disable the Search Service?
Any help or advice will be very important to me...
Thanks,Search service is a shared service by all SQL Server instances.

Can you take off-line on SQL Server FullText resources from all SQL Server instances from cluster administrator?

You shouldn't remove the search service even though you currently do not use it. Try take it off-line.

Becuase your search service is in unknow status, I would move all cluster groups to the good node and restart the machine that search service is not function properly.|||Hi Allen_Cui

Thank you for your reply...
I have already tried to move all the groups to the good node and the result was:
Microsoft Search is in "stopped" state in Service Manager... -> that's ok!
SQL Server Full Text resource was in "failed" state in cluster Administrator... -> that's not ok!
But before I try the manual failover I selected the option "Do not restart" in the properties of the failed Full Text Resource...
My problem now is: I want to convert the state of the failed Full Text Resource to an offline state the is more pleasant to see...
Do you have any idea?
I will be waiting for your help...|||I would check the machine application/system logs to see any errors related FullText resource and search service.

Wednesday, March 7, 2012

how to delete reference to fulltext catalog

Looks like I made a mistake I hope someone can help me with. I backed
up a SQL database that implements fulltext catalogs. I thought these
would be included in the backup...I was wrong. Not a problem to
recreate the catalogs except that the database still shows the
references to the old ones. It gives me an error if I try to delete. I
get an error if I try to rebuild. I have also tried command line with
no luck:
use dev_i3
EXEC sp_fulltext_catalog 'fcAttachment', 'drop'
I appear to be stuck because I have catalog references to catalogs that
do not exist on the new server. There must be a way to manually remove
this reference and start over...I hope!
Thanks in advance.
I hope you have found a solution but if not here's my 2 cents...
First, you'll want to double-check that full-text is enabled on the database
in the new server. (see sp_fulltext_database in BOL) If not, do so and try
once more to start a rebuild on the catalogs. If this doesn't work, you'll
need to manually delete the catalogs from the sysfulltextcatalogs table and
recreate the full-text catalogs (see sp_fulltext_catalog). This should get
your catalogs back online.
Thankfully, in SQL Server 2005, the FT catalogs will be backed up and
restored as part of the database.