The backup of the file or filegroup "sysft_ FullTextCatalog" is not permitted (MS SQL database backup)

ServosityPro: All
OS: Windows

When performing a MS SQL database backup, the following error message is received in the backup report:

Backup Logs  No.  Type  Timestamp  Backup Logs *  Info ...  ... *  Error YYYY/MM/DD hh:mm [Microsoft][ODBC SQL Server Driver][SQL Server] The backup of the file or filegroup "sysft_ FullTextCatalog" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. *  Info ...  ... *  Error YYYY/MM/DD hh:mm  [Microsoft][ODBC SQL Server Driver][SQL Server] BACKUP LOG is terminating abnormally.

The message suggests that a full-text catalog in the database is not online. To perform a full database backup, SQL Server 2005 requires all the database files and full-text catalogs in the database to be online.

To resolve the issue, please follow the instructions below:

1. Locate the folder that contains the files for the problematic full-text catalog
2. Run the ALTER DATABASE statement. Specify in the statement the correct location for the full-text catalog
3. Rebuild the problematic full-text catalog in the database
4. Perform a full backup of the database again