One of our Database with Full Text Catalog is not getting backed up. When I checked, backup keeps pending on 0% without any progress. In SQL server error log, I also found error related to Full text catalog that SQL server is facing issue in setting Full test catalog status.
These is some issue with FTS service due to which when backup ask FTS service to change Full text catalog status, it failed.
SQL server backup change status between PAUSE & RESUME before & after backup.
Failed to change the status to RESUME for full-text catalog “Test_FullTextCatalog” in database “Test”. Error: 0x80043607(An internal interface is being used after the corresponding catalog has been shutdown. The operation will be aborted.).
You need to restart the Full Text service to resolve the issue.
I have restarted the FTS & try backup again and it worked successful.
Please share if you face any more issue in this regard or any other possible solution.
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (https://mssqlfun.com/)