MSSQLSERVER_9987
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
Details
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. |
Explanation
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.
User Action
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.
Note
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.
See Also
Other Resources
Backing Up and Restoring a Full-Text Index
File Backup and Restore and Full-Text Catalogs
Full-Text Search Administrator InfoCenter
How to: Attach a Database (SQL Server Management Studio)
How to: Back Up Database Files and Filegroups (SQL Server Management Studio)
How to: Back Up Files and Filegroups (Transact-SQL)
How to: Create a Full-Text Catalog (SQL Server Management Studio)
How to: Detach a Database (SQL Server Management Studio)
How to: Enable a Database for Full-Text Indexing (SQL Server Management Studio)
How to: Rebuild a Full-Text Catalog (SQL Server Management Studio)
How to: Rebuild All Full-Text Catalogs of a Database (SQL Server Management Studio)
How to: Remove a Full-Text Catalog from a Database (SQL Server Management Studio)
How to: Restore Files and Filegroups (SQL Server Management Studio)
ALTER DATABASE (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
BACKUP (Transact-SQL)
CREATE DATABASE (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT INDEX (Transact-SQL)
sp_detach_db (Transact-SQL)
sp_fulltext_catalog (Transact-SQL)
sp_fulltext_database (Transact-SQL)