Friday 24 February 2012

Conflict between backup and fulltext catalog

Sometimes the scheduled full backups on MY_DATABASE are not performed,
throwing the following error related with the fulltext catalog (CATALOG_XXX)
that it's used by some tables:
"The backup of the file or filegroup "sysft_CatalogXXX" 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). The step failed."
How do I solve this error?
Thanks,
Gaspar.Are you trying to execute a backup while the fulltext catalog is being
rebuilt?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Gaspar" <gaspar@.gaspar.com> wrote in message
news:utLKzokYGHA.4248@.TK2MSFTNGP05.phx.gbl...
> Sometimes the scheduled full backups on MY_DATABASE are not performed,
> throwing the following error related with the fulltext catalog
> (CATALOG_XXX) that it's used by some tables:
> "The backup of the file or filegroup "sysft_CatalogXXX" 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 abnormal
ly.
> [SQLSTATE 42000] (Error 3013). The step failed."
> How do I solve this error?
> Thanks,
> Gaspar.
>

No comments:

Post a Comment