Articles in this section

See more

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

Brad Alexander
  • Updated
Follow
  1. Product Version:
    2. ServosityPro: All
    OS: Windows
  2. Problem Description:
    3. 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.
  3. Cause:
    4. 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.
  4. Resolution:
    5. 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
  5. Also See:
    6. http://support.microsoft.com/kb/923355