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?

  • I'd start with a security review to see who has access to the server and that level of access within SQL Server. The "one day we noticed" is worrisome; you should get notifications any time backups fail to run to completion. – UnhandledExcepSean Feb 4 '19 at 20:20
  • We did a security investigation, but we couldn't find anything unusual on the windows server logs or SQL server logs. The backup issue started on weekend after business hours, even though we got notification about backup failure, we noticed it on Monday morning only. – Kurisinkal Feb 7 '19 at 14:05
  • Have you searched he server to see if someone might have accidentally moved it? I've seen accidental drag operations break production only to find the folder was dragged into a subfolder. – UnhandledExcepSean Feb 7 '19 at 14:38
  • But I assume once SQL Server is attached to these catalog files, we cant remove/rename it without detaching DB or make it offline. So possibility of accidental move is very less. – Kurisinkal Feb 11 '19 at 18:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.