SQL 2005 backups fail on specific databases with error "The backup of full-text catalog 'FullTextCatalog' is not permitted because it is not online."

Article:TECH63566  |  Created: 2008-01-25  |  Updated: 2012-01-26  |  Article URL http://www.symantec.com/docs/TECH63566
Article Type
Technical Solution

Product(s)

Issue



SQL 2005 backups fail on specific databases with error "The backup of full-text catalog 'FullTextCatalog' is not permitted because it is not online."


Error



The backup of full-text catalog 'FullTextCatalog' 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 by using the FILEGROUP or FILE causes to restrict the selection to 

When performing a full backup of a database in Microsoft SQL Server 2005, an error message that resembles the following can be displayed:
 
Backup failed for Server 'ComputerName\SQLInstanceName'. (Microsoft.SqlServer.Smo)
 
Additional information: 
System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_ FullTextCatalog" 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. (Microsoft.SqlServer.Smo)
 
If a full backup of a database in SQL Server 2005 Service Pack 2 (SP2) is performed, the following error message may be generated:  
The backup of full-text catalog 'FullTextCatalog' is not permitted because it is not online. Check the SQL error log file for the reason that full-text catalog becomes offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

Solution



1. Locate the folder that contains the files for the problematic full-text catalog.
 
2. Run the ALTER DATABASE statement. Specify in the statement the correct location for the full-text catalog.
 
3. Rebuild the problematic full-text catalog in the database.
 
Refer to examples and Section B  http://msdn.microsoft.com/en-us/library/ms189801.aspx for more information.
 
4. Perform a full backup of the database in SQL Server 2005 again.
 
Refer to  http://support.microsoft.com/kb/923355 for more information.
 

As an alternative to the above steps, you can try the following command to resolve the issue:

ALTER FULLTEXT CATALOG sysft_ FullTextCatalog REBUILD WITH ACCENT_SENSITIVITY=OFF;

Reference : http://msdn.microsoft.com/en-us/library/ms176095(SQL.90).aspx


Supplemental Materials

SourceUMI
ValueV-79-65323-9987
Description

The backup of full-text catalog 'FullTextCatalog' is not permitted because it is not online.



Legacy ID



308889


Article URL http://www.symantec.com/docs/TECH63566


Terms of use for this information are found in Legal Notices