locked
Error occur while talking backup in SQL server 2005 RRS feed

  • Question

  • Hi ,

    I am getting the following error while taking backup in SQL server 2005,

    "Failed to pause full-text catalog for backup. Backup was aborted. Check to make sure Microsoft Full-text Service is running properly and SQL server service have access to full-text service."

    Please can anyone tell how to solve this error?

    Regards,

    Karthik.

    Friday, November 18, 2011 5:52 AM

Answers

  • "Failed to pause full-text catalog for backup. Backup was aborted. Check to make sure Microsoft Full-text Service is running properly and SQL server service have access to full-text service."

    Hi Karthik,

    This issue may occur if the 'SQL Server Full Text Search' or 'Microsoft Search Service' is not started on the SQL Server during the SQL database backup.You could check if the full text service is running. This can be found by opening up the windows services and locating either "SQL Server Full Text Search" or "Microsoft Search Service". If it's not running or disabled then this may be your problem- Retry the backup.And you need to ensure full text catalog is enabled on the databases by running the following command:

    exec sp_fulltext_database 'enable'
    

    If all of the above fails take a note of how the full text catalog is set up on the database in question. It should be accessible via Storage -> Full Text Catalogs. When you see what tables and fields it references try dropping and recreating the full text catalog. Retry the backup.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Peja Tao Thursday, November 24, 2011 8:24 AM
    Monday, November 21, 2011 5:39 AM