Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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:
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.
1 | EXEC sp_fulltext_table 'table_name', 'drop' |
You can now remove the Full-Text Catalog with the following code:
1 | DROP FULLTEXT CATALOG fulltext_catalog_name |
