Enabling Fulltext Service on database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David De Giacomi [dotNetHell.it] - 23 Feb 2006 10:34 GMT

Hi guys,
one of my customers moved a SQL Database from one server
to another. The database had 2 fulltext catalogs associated.
On the new DB Server the fulltext service doesn't start using
sp_fulltext_database 'enable'.
QA shows "Executing Query Batch..." but never returns.

I googled on the newsgroups and found the solution to update the
path in the sysfulltextcatalogs to a physical existent folder on the
new server. I tried again with sp_fulltext_database but again it
doesn't work.

The only thing I need is to clean/remove the two catalogs, rebuild
them and enabling the fulltext. What can I do ?
I read also the support ms doc #240867.

So, what am I missing ? Thank you all.

Signature

David De Giacomi
Microsoft MVP
Blog @ http://blogs.dotnethell.it/david/
http://www.dotnethell.it

Reply to this Message

Hilary Cotter - 23 Feb 2006 12:26 GMT

sp_fulltext_database 'disable' in your problem database and run profiler to
see where it is getting stuck (if it does at all). Then I would try to
reenable it (sp_fulltext_database 'enable') and again run profiler to see
where it is getting stuck.

Make sure you kick all users out of this database when you run this command.
I would also bounce the box if you have this luxury before running this
command.

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

> Hi guys,
> one of my customers moved a SQL Database from one server
[quoted text clipped - 13 lines]
>
> So, what am I missing ? Thank you all.

Reply to this Message