- Product Version:
- Problem Description:
- Cause:
- Resolution:
- Also See:
ServosityPro: All
OS: Windows
OS: Windows
When performing a MS SQL database backup, the following error message is received in the backup report:
|
The message suggests that a full-text catalog in the database is not online. To perform a full database backup, SQL Server 2005 requires all the database files and full-text catalogs in the database to be online.
To resolve the issue, please follow the instructions below:
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 again
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 again