Friday 9 October 2009

"Failed to pause full-text catalog for backup" while backing up a database

So you're trying to back up your database and you get the following error:

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.


There are a couple of things that could be up here. Try all of the following and see if that get's you out of this:

1. 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.

2. Ensure full text catalog is enabled on the databases by running the following command:

exec sp_fulltext_database 'enable'

Retry the backup.

3. 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.


Hope this helps!


Karma Gardas Snippets Diary - Blogged

No comments:

Post a Comment

Note: only a member of this blog may post a comment.