question

DaniSQL avatar image
DaniSQL asked

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.

sql-server-2005full-textsearch
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image
DaniSQL answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steinar avatar image
Steinar answered

To remove full text index, From MSDN:

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

2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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?
0 Likes 0 ·
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?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.