Arcserve Backup Version > Applicable to all versions of Arcserve Backup
Product Name > Arcserve Backup
Arcserve Backup Agents and Options > Agent For Microsoft SQL Server
Arcserve Backup Task > Backup Operation
AE50015 - Backup failed. (Microsoft SQL Server Error 9987 (ODBC State ="37000"): [Microsoft][ODBC SQL Server Driver][SQL Server]The backup of full-text catalog 'NAME_OF_THE_CATALOG_ITEM' is not permitted because it is not online. Check error log file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed)
This behavior occurs because a full-text catalog in the database is not online. To perform a full backup, SQL Server 2005 requires all the database files and full-text catalogs in the database to be online.
"Backup of full-text catalog not permitted because it not online" occurs during a full backup of Microsoft SQL 2005 Databases.
Possible Reasons :
The full-text catalog may not be online because one or more of the following conditions are true:
1.The full-text catalog folder is either deleted or corrupted.
2.You did not enable the database for full-text indexing.
3.The database is restored from a Microsoft SQL Server 2000 database backup. Therefore, the folder of the full-text catalog in the Database does not exist on the server where you restore the database.
4.The instance of SQL Server 2005 that you are running was upgraded from SQL Server 2000. However, the full-text search service.
5.cannot be accessed during the upgrade.
6.The database is attached from somewhere. However, you specify the incorrect location for the full-text catalog folder during the attachment.
To work around this Problem, follow the below steps
1. Login to SQL Management Studio, navigate to the Database which has the problem with the Full-text catalog.
Note : Full-text catalogs can be found under the SQL server->Databases-> Database->Storage.
2. Take the Database offline or Put the Database in to a Single User mode (to further prevent any database corruption while detaching).
3. Detach the database.
4. Reattach the database.
5. Get the Database Online.
6. Run a rebuild against the Full-text catalog by right click on the Problematic full text catalog.
7. Re run the backup for the SQL database in Question.
8. Back up should now be successful.
If the problem still exists, please refer the below KB from Microsoft which has an alternate solution to this problem