After upgrading SQL server
database from SQL server 2000 to SQL server 2005. When you perform a
full database backup of a SQL server 2005 database, you may got
following error message on your system screen.
Executing
the query "Backup Database [ZZZ] TO [ZZZ]
WITH
NOFORMAT, NOINIT, NAME = N'ZZZ_backup_20060819040020', SKIP, REWIND,
NOUNLOAD, STATS = 10
"failed
with the following error:
"The
backup of the file or filegroup "sysft_ZZZ_FT" 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. BACKUP DATABASE is
terminating abnormally.".
Cause: SQL server
error 3007 may occur when fulltext catalog is offline for the
database ZZZ.
Resolution: You can
resolve this error message with the help of two methods: SQL server
management studio and drop & rebuild catalog .
With SQL server
management studio: It is the simplest action to resolve error
3007. Follow below steps to resolve it.
- Open SQL server management studio (SSMS).
- Now go-to the storage container.
- Check the state of fulltext catalog.
- If there is a problem then resolve it.
- Now you will able to backup your database.
With Drop & Rebuild
Catalog: If you are still unable to backup your database then
drop & rebuild the catalog if catalog is needed otherwise drop
it.
Note: You can take
backup of your database when rebuild start. There is no need to wait
for rebuild catalog.
