Error: Msg 62309, Level 19, State 1, Line 1 SQL Server has returned a failure message to LiteSpeed 2005 which has prevented the operation from succeeding. The following message is not a LiteSpeed 2005 message. Please refer to SQL Server books online or Microsoft technical support for a solution: BACKUP DATABASE is terminating abnormally.
This behavior occurs because a full-text catalog in the database is not online. 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.
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. For more information about how to use the ALTER DATABASE statement in this scenario, visit the following Microsoft Developer Network (MSDN) Web site, and then search for the Moving Full-Text Catalogs topic:
https://msdn.microsoft.com/en-us/library/ms345483.aspx
3. Rebuild the problematic full-text catalog in the database.
4. Perform a full backup of the database in SQL Server 2005 again.
Notes:
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. For more information about how to enable a database for full-text indexing in SQL Server 2005, visit the following MSDN Web site:
https://msdn.microsoft.com/en-us/library/ms403375.aspx
If the full-text catalog is not required, drop the problematic full-text catalog. Then, perform a full backup of the database in SQL Server 2005.
If you perform a full backup of a database in SQL Server 2005 Service Pack 2 (SP2), you may receive a similarerror message:
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 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.
For additional information, see:
https://support.microsoft.com/en-us/kb/923355
In SQL Server Configuration Manager and change the full-text daemon launcher to use the same account as the SQL Server instance.
Start -> Programs -> Microsoft Sql Server 2008 -> Configuration Tools -> Sql Server Configuration Manager"
Also see the Microsoft post discussing running Full Text:
Leave a Comment
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center