SQL Backup Agent Service not starting

ToehoToeho Posts: 73
edited June 3, 2009 10:55AM in SQL Backup Previous Versions
I have a 2 node cluster that I can not get the SQL Backup Agent service to start on. The services get created correctly in the cluster and on both nodes but when the installer tries to bring the service online it fails. I see a SQBCORESERVICE.exe running but the actual service stays in a "Starting" status and the cluster resource shows as failed.

Errors from the installer are:

IDXDW05\IDXDW05: Server Component Installation - Failed
=======================================================

Copy SQBServerSetup.exe to server - Successful

This operation completed successfully.


Run setup on server - Successful

This operation completed successfully.


Start SQL Backup Agent service - Failed

The SQL Backup Agent service cannot start, or is taking too long to start up.

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server.



Check installed versions - Failed

Error opening mutex.


Check SQLBackup extended stored procedures - Successful

This operation completed successfully.


Delete setup file from server - Successful

This operation completed successfully.


Updating SQL Server information - Failed

Error opening mutex.

Comments

  • Eddie DEddie D Posts: 1,647 Rose Gold 5
    Thank you for your post into the forum and sorry that this problem has occurred.

    I suspect that this is a named instance of SQL on your cluster, where the service is not starting correctly.

    If this is a named SQL Instance, can you please check the following registry key on each node of the cluster has the -i <SQL Instance Name> at the end of the path specified:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent_<SQL Instance Name>

    You will find a registry key called ImagePath.
    The data value for this key is the path to the SQBCoreService.exe, does the path have the -i <SQL Instance Name> switch at the end of the path specified? If the answer is no, please add the -i <SQL Instance Name>.

    For Example using a named instance called SQL2005

    I locate the ImagePath Registry Key in the following Registry Folder path:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent_SQL2005

    Upon checking the ImagePath key is does not have the -i parameter:
    C:\Program Files\Red Gate\SQL Backup\SQL2005\SQBCoreService.exe

    Add the -i parameter so the path becomes:
    C:\Program Files\Red Gate\SQL Backup\SQL2005\SQBCoreService.exe -i SQL2005

    Now attempt to start the SQL Backup Agent.

    In some cases you may have to re-boot the server for the change to take effect.

    Remember to perform the above on the other cluster nodes.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.