Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_9987

SQL Server 2005

New: 12 December 2006

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.3042

Event ID

9987

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

FTXT2_DISALLOW_BACKUP_OF_OFFLINE_DATA

Message Text

The backup of full-text catalog '%ls' is not permitted because it is not online. Check errorlog 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 clauses to restrict the selection to include only online data.

The backup operation is trying to access one or more offline full-text catalogs.

Possible reasons for a full-text catalog to be offline include the following:

  • sp_fulltext_database 'disable' was executed on the database.
  • Corruption was detected in the full-text catalog and it was automatically taken offline.
  • An invalid full-text catalog path was detected during an attach or upgrade operation.

Check the SQL Server error log for information about why the catalog went offline.

Possible user actions depend partly on the cause of the problem. The possible actions include the following:

  • If the full-text catalog is offline because the database was attached with an invalid full-text catalog path, detach the database and reattach it with the correct full-text catalog path.
    To use Transact-SQL, use the following statements:
    • sp_detach_db
    • CREATE DATABASE
    For information about how to use SQL Server Management Studio, see "How to: Detach a Database (SQL Server Management Studio)" and "How to: Attach a Database (SQL Server Management Studio)" in SQL Server 2005 Books Online.
  • If the full-text catalog path is valid, bring the full-text catalog online by rebuilding it.
    Bb326385.note(en-US,SQL.90).gifNote:
    If the path is invalid, move the full-text catalog directory to the correct location by using the ALTER DATABASE statement with the MODIFY FILE option.

    To rebuild a catalog with a valid path, you can either:
    • Use the sp_fulltext_catalog stored procedure.
    • Use the ALTER FULLTEXT CATALOG statement.
    • Use SQL Server Management Studio. For more information, see "How to: Rebuild a Full-Text Catalog (SQL Server Management Studio)" or "How to: Rebuild All Full-Text Catalogs of a Database (SQL Server Management Studio)"in SQL Server 2005 Books Online.
  • Perform a file backup by listing all the data files except for the full-text files.
    For more information, see "How to: Back Up Files and Filegroups (Transact-SQL)" or "How to: Back Up Database Files and Filegroups (SQL Server Management Studio)" in SQL Server 2005 Books Online.
  • Drop and re-create the full-text catalog.
    To use Transact-SQL, use the following statements:
    • DROP FULLTEXT INDEX
    • DROP FULLTEXT CATALOG
    • CREATE FULLTEXT INDEX
    • CREATE FULLTEXT CATALOG
    For information about using SQL Server Management Studio, see "How to: Create a Full-Text Catalog (SQL Server Management Studio)" and "How to: Remove a Full-Text Catalog from a Database (SQL Server Management Studio)" in SQL Server 2005 Books Online.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft