The backup of the file or filegroup "sysft_ftcat_documentindex" is not permitted ...

Introduction

After upgrading MSCRM database from Microsoft SQL server 2000 to 2005, the following error message may appear when creating backups of the database.

Issue

SQL Error Message:
The backup of the file or filegroup "sysft_ftcat_documentindex" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. [SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)

Resolution

Make sure you are able to return to previous state (before running the following query) by at least creating copies of the data files.

Run the following query on CompanyName_MSCRM database.
ALTER FULLTEXT CATALOG ftcat_documentindex REBUILD;