SQL 2005 database unable to backup due to offline full-text catalog

Technorati Tags: SQL Server

Ran into this issue with a CRM database that had been detached, copied, and re-attached by someone else.  SQL backup job was failing on this database with error “The backup of full-text catalog “ftcat_XXXXX” is not permitted because it is not online.”  This appeared to be due to missing full-text catalog errors. 

1. Ran “SELECT name, ftcatid FROM sysobjects WHERE ftcatid > 0” on the database to find the tables using catalog.

2. Then ran “EXEC sp_fulltext_table 'tbl_whichtable', 'drop'” on the table to stop using the full-text catalog

3. Ran “DROP FULLTEXT catalog ftcat_XXXXX” to drop the catalog.

4. Re-created full-text index and catalog on the table

5. Verified full database backup completed successfully.