KB labels


Ticket Product Version

Ticket Category

Ticket Assignee


Hot Fixes

Published Fixes
Your Arcserve Support User Profile
First Name:
Last Name:
email:
Phone:
Company:*
Customer Type:
Language:

Country:
Region:

Time zone:
Follow

arcserve-KB : 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 errorlog file.

Last Update: 2015-08-26 08:05:05 UTC

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

Error Message

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)

Cause :

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.
Description:

"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.
 
Solution:


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.

More Information:

If the problem still exists, please refer the below KB from Microsoft which has an alternate solution to this problem

http://support.microsoft.com/kb/923355

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments