How to turn on verbose logging for SQBCoreService Service

DBA72

I have a problem starting up the SQL Backup Agent service (SQBCoreService.exe Version 6.2.0.134). Whenever I start it up it hangs for a while and then fails to start. I've checked the following:

SQL Rights = OK
ProcMon = Don't see any problems
EventLogs = Just says that the service failed to start. Nothing usefull in security log

Is there any way to start this service in a verbose logging mode so that I can see what it is having problems with?

Brian Donahue

Thanks for your question -- yes, there is a very verbose logging capability for SQL Backup Agent. When you add "-sqbdebug" to the service satrtup parameters and restart, you will get a "SQBCoreService_log.txt" file created in the SQBCoreService.exe folder. We have got a VBScript that you can run to make the process a bit easier: download ftp://support.red-gate.com/utilities/Ch ... nstall.zip and run cscript SQBDebug.vbs.