Database backup with full text search catalog

To perform a full backup, SQL Server 2005 requires all the database files and full-text catalogs in the database to be online.

The full-text catalog may be online because one or more of the following conditions are true:

• The full-text catalog folder is either deleted or corrupted.
• You did not enable the database for full-text indexing.
• 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.
• The instance of SQL Server 2005 that you are running was upgraded from SQL Server 2000. However, the full-text search service cannot be accessed during the upgrade.
• 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 behavior, follow these steps:

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.
4. Perform a full backup of the database in SQL Server 2005 again.

• If you have not enabled the database for full-text indexing, you must enable this option first before you can perform a full backup of the database in SQL Server 2005.
  
  
• If you do not need the full-text catalog any longer, you can drop the problematic full-text catalog. Then, perform a full backup of the database in SQL Server 2005.