I have SQL Server 2005 database. One day we noticed the production backup is not running, and the cause was that the full text catalog was offline. Further analysis showed that the full text catalog file is missing in the folder. We checked the error logs, but could not find any reason for this deletion.
Is there any possibility in SQL Server 2005 for catalog files getting deleted automatically?
Can anyone remove this file manually via Management Studio?