Issue :-
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.).
Solution :-
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 (http://mssqlfun.com/)
Hey there this is somewhat of off topic but I was wanting to know if blogs use WYSIWYG editors
or if you have to manually code with HTML. I’m starting a blog soon but
have no coding expertise so I wanted to get advice
from someone with experience. Any help would be enormously appreciated!
I am using WYSIWYG approach. WordPress.com is quite useful site for blogging.