Long Running Backup Job and SQL Server FullText Search...State "Change Pending"

BAck up of 5GB database run for 12 hrs and when I investigate things are pointing toward FullText search on the database. I rebuild FTS catalogue but problem still persists. So I tried restarting Server FullText Search Service and now the state of FTS is "Change Pending....". I tried to stop and restart but with no luck. How can I fully restart search service and change its state to "Running"?

update: I run the following query on the index catalog in question select fulltextcatalogproperty('MyCatalog', 'PopulateStatus') and no results after running 20min. What do I do to drop or fix this index catalog? I couldnt even take backups. Please Help! Its driving me crazyyyyyyyyy. Thank you.

asked Jan 31 '10 at 12:17 AM in Default

DaniSQL
4.8k ● 30 ● 35 ● 39

(comments are locked)

2 answers:

Thank you all. I finally solved the problem by restarting SQL Server and Stopped the FullText search service using task manager. Then I remove the FullText catalog from all the databases that have it and I was able to take backup with out a problem. However, I still dont know what causes the corruption on the FullText Catalogue in the first place.

answered Feb 07 '10 at 11:10 PM

DaniSQL
4.8k ● 30 ● 35 ● 39

(comments are locked)

To remove full text index, From MSDN:

USE AdventureWorks; GO DROP FULLTEXT INDEX ON HumanResources.JobCandidate; GO

answered Feb 01 '10 at 06:09 AM

Steinar
1.7k ● 3 ● 4 ● 6

I tried that, but it couldn't do it. Process goes forever executing the query. Any Idea why? Also If I drop it successfully can I recreate it without problem on the application?

Feb 01 '10 at 10:17 AM DaniSQL

Well, if it goes on forever, look in actovity monitor to see if it is blocked by some other process. How big is this index?

Feb 02 '10 at 06:37 AM Steinar

(comments are locked)