March 3, 2011 at 10:40 am
I'm getting the following error when trying to backup a database that has a full-text catalog on it.
Msg 7694, Level 16, State 1, Line 1
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.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
It started after I changed the service account the SQL services run as. I changed the account using the SQL configuration manager tool, have the full-text service running as the same account as the SQL service, and have that user running as a sysadmin.
Are there any other special permissions that service account needs to be able to work with full-text indexes beyond what the configuration manager would have granted it? I'm not a full-text guru, so I'm at a loss here.
Thanks,
Jason
The Redneck DBA
March 3, 2011 at 11:28 am
Please check if the SQL Server FullText Search service is running.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 3, 2011 at 11:31 am
Yep, it's running.
The Redneck DBA
March 3, 2011 at 11:33 am
There is nothing much I can recollect to fix this issue. Please check if dropping and recreating the FULL TEXT Index helps.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 5, 2011 at 8:32 am
I tried to rebuilt it, and it just sat there seemingly doing nothing for a couple of hours. I finally got to poking around and the folder/files that made up the catalog were somehow totally missing. I finally just dropped and recreated the catalog and index and all was good.
How it went missing and why it wasn't breaking our application (CRM) that was using it I don't know, but all is good now.
Thanks for the pointers.
The Redneck DBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply