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.

more ▼

asked Jan 31, 2010 at 12:17 AM in Default

DaniSQL gravatar image

4.9k 33 35 39

(comments are locked)
10|1200 characters needed characters left

2 answers: sort newest

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.

more ▼

answered Feb 07, 2010 at 11:10 PM

DaniSQL gravatar image

4.9k 33 35 39

(comments are locked)
10|1200 characters needed characters left

To remove full text index, From MSDN:

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

more ▼

answered Feb 01, 2010 at 06:09 AM

Steinar gravatar image

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, 2010 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, 2010 at 06:37 AM Steinar
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 31, 2010 at 12:17 AM

Seen: 2668 times

Last Updated: Feb 05, 2010 at 01:26 PM