SQL Backup 6

SQL Server error 3007 - The backup of the file or filegroup sysft_FTX_MyDatabase is not permitted because it is not online

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.

  1. Open SQL Server Management Studio and, in the Object Explorer, expand the relevant database.
  2. Expand Storage > Full Text Catalogs.
  3. 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).


Didn't find what you were looking for?