About 5 min after I posted it I realized I was putting the ending double quote right after the path which was excluding the WITH SINGLERESULTSET command.

Now my problem is that in SQLBackup 6.0+ it works fine but in SQLBackup 5.4.0.55 I'm getting a syntax error saying that there's a syntax error SINGLERESULTSET after WITH. But it says this is supported since 5.3. Can anyone tell me if this is a mistake?

The version of SQBCoreService.exe you are using needs to be 5.3.0.178 or newer. To upgrade this file:

- locate the SQBServerSetup.exe file on any workstation that has the SQL Backup GUI installed. The file will be located in the SQL Backup installation folder. The version should be 5.4.0.55, since that's the version of your GUI.

- copy SQBServerSetup.exe to the box running your SQL Server instance

- ensure no SQL Backup processes are running, and if possible, no SQL Backup GUIs are connected to that SQL Server instance.

- run SQBServerSetup.exe on the box

This will upgrade the SQL Backup Agent service, the command line interface, and the extended stored procedures to version 5.4.0.55.