"Backup of full-text catalog not permitted because it not online" occurs during a full backup of SQL 2005 Databases.

Article:TECH64785  |  Created: 2008-01-04  |  Updated: 2014-01-14  |  Article URL http://www.symantec.com/docs/TECH64785
Article Type
Technical Solution


Issue



"Backup of full-text catalog not permitted because it not online" occurs during a full backup of SQL 2005 Databases.


Error



V-79-57344-33938 - Backup of full-text catalog not permitted because it not online.


Cause



This behavior occurs because a full-text catalog in the database is not online. To perform a full backup, SQL Server 2005 requires all the database files and full-text catalogs in the database to be online.


Solution



As per Microosft Kb Article:
Follow these steps:
  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.

    For more information about how to use the ALTER DATABASE statement in this scenario, visit the following Microsoft Developer Network (MSDN) Web site, and then search for the "Moving Full-Text Catalogs" topic:
  3. Rebuild the problematic full-text catalog in the database.
  4. Perform a full backup of the database in SQL Server 2005 again.
Please refer to the following Microsoft KB article for more information:  
 http://support.microsoft.com/kb/923355 - Error message when you perform a full backup of a database in SQL Server 2005: "Backup failed for Server 'ComputerName\SQLInstanceName' " or "The backup of the file or filegroup 'sysft_FullTextCatalog' is not permitted because it is not online" 

Supplemental Materials

SourceUMI
ValueV-79-57344-33938


Legacy ID



313476


Article URL http://www.symantec.com/docs/TECH64785


Terms of use for this information are found in Legal Notices