SQL Server error 3007 - The backup of the file or filegroup sysft_FTX_MyDatabase is not permitted because it is not online
Published 18 February 2013
When performing a full backup of a SQL Server 2005 database, the following error may occur:
SQL error 3007: The backup of the file or filegroup "sysft_FTX_MyDatabase" is not permitted because it is not online.
This error may be caused by problems with the full-text catalog.
- Open SQL Server Management Studio and, in the Object Explorer, expand the relevant database.
- Expand Storage > Full Text Catalogs.
- Right-click the relevant catalog and select Rebuild.
SQL Server should now consider the full-text catalog "online" and you can take a full backup of the database.
For more information about repairing full-text catalogs, see Microsoft Support (KB 923355).