Could not backup database: The backup of full-text catalog ‘index_name’ is not permitted because it is not online

Ekrem Önsoy

6 years ago

ERROR MESAGGE:

“Could not backup database: The backup of full-text catalog ‘index_name’ is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.”

EXPLANATION:

If the Full-text Catalog in the database you are trying to backup is not Online, then you may encounter this error when trying to get backup.

SOLUTION:

Run the following code to determine which table is using the Full-Text Index:

SELECT name, ftcatid FROM sysobjects WHERE ftcatid > 0

1	SELECT name, ftcatid FROM sysobjects WHERE ftcatid > 0

After running this command, tables that use Full-Text will be listed.

Remove the full-text index metadata for the related table with the below script.

EXEC sp_fulltext_table 'table_name', 'drop'

1	EXEC sp_fulltext_table 'table_name', 'drop'

You can now remove the Full-Text Catalog with the following code:

DROP FULLTEXT CATALOG fulltext_catalog_name

1	DROP FULLTEXT CATALOG fulltext_catalog_name