The backup operation is trying to access one or more offline full-text catalogs.

Possible reasons for a full-text catalog to be offline include the following:

• sp_fulltext_database 'disable' was executed on the database.
  
• Corruption was detected in the full-text catalog and it was automatically taken offline.
  
• An invalid full-text catalog path was detected during an attach or upgrade operation.
  

Check the SQL Server error log for information about why the catalog went offline.

Possible user actions depend partly on the cause of the problem. The possible actions include the following:

• If the full-text catalog is offline because the database was attached with an invalid full-text catalog path, detach the database and reattach it with the correct full-text catalog path.
  To use Transact-SQL, use the following statements:
  
  • sp_detach_db
    
  • CREATE DATABASE
    
  For information about how to use SQL Server Management Studio, see "How to: Detach a Database (SQL Server Management Studio)" and "How to: Attach a Database (SQL Server Management Studio)" in SQL Server 2005 Books Online.
  
• If the full-text catalog path is valid, bring the full-text catalog online by rebuilding it.
  

  Note:
  If the path is invalid, move the full-text catalog directory to the correct location by using the ALTER DATABASE statement with the MODIFY FILE option.

  To rebuild a catalog with a valid path, you can either:
  
  • Use the sp_fulltext_catalog stored procedure.
    
  • Use the ALTER FULLTEXT CATALOG statement.
    
  • Use SQL Server Management Studio. For more information, see "How to: Rebuild a Full-Text Catalog (SQL Server Management Studio)" or "How to: Rebuild All Full-Text Catalogs of a Database (SQL Server Management Studio)"in SQL Server 2005 Books Online.
    
• Perform a file backup by listing all the data files except for the full-text files.
  For more information, see "How to: Back Up Files and Filegroups (Transact-SQL)" or "How to: Back Up Database Files and Filegroups (SQL Server Management Studio)" in SQL Server 2005 Books Online.
  
• Drop and re-create the full-text catalog.
  To use Transact-SQL, use the following statements:
  
  • DROP FULLTEXT INDEX
    
  • DROP FULLTEXT CATALOG
    
  • CREATE FULLTEXT INDEX
    
  • CREATE FULLTEXT CATALOG
    
  For information about using SQL Server Management Studio, see "How to: Create a Full-Text Catalog (SQL Server Management Studio)" and "How to: Remove a Full-Text Catalog from a Database (SQL Server Management Studio)" in SQL Server 2005 Books Online.
  

Other Resources

Help and Information