Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am running SQL Server 2005 EE.

When trying to perform a full database backup I receive the error message:

Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating abnormally.

After googling the issue, it seemed to be related to Full-Text Search not running properly, and so I checked and sure enough FTS was stopped. However, when attempting to start FTS, I recieved the following error message:

Service Dependency Deleted (ObjectExplorer)

I googled this error and found the following advice in a WordPress blog (kind of worried about following this advice as there was no explanation about why I would do this).

  1. Open the registry key HKEY_LOCAL_MACHINE\System\CurrentControlSet \Services\msftesql
  2. Rename the value DependOnService to anything
  3. Restart the server

Any advice would be greatly appreciated.

Thanks!

share|improve this question
1  
Did you try the registry changes? Seems pretty harmless to put it back if the change does nothing. –  Jon Seigel Jun 23 '11 at 4:16
    
What version of Windows Server are you using? I've seen this before with SQL Server 2005 on Windows Server 2008. Issue relates to depending on a service that is not present in Windows Server >2003. –  Dylan Knoll Nov 28 '14 at 0:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.