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 am not able to kill two blocked processes and I also couldnt even take backups. Please Help! Its driving me crazyyyyyyyyy. Thank you.

sql-server-2005full-text
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
RickD avatar image
RickD answered

If you restarted the services, the Catalogue (and probably the database), will go into recovery mode. If you check your log, you should see messages about what percentage has been recovered so far. You need to wait for these to finish before even trying to do anything else as it will take as long as it takes.

If this isn't fast enough, the only other way around is to restore from an earlier backup, you will lose data this way though.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

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.