SQL Backup Agent Service not starting
Toeho
Posts: 73
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.
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com