SQL Backup job failed with exit code: 0
I have installed sqlbackup 4 pro edition on multiple servers now and it works fine until yesterday when I installed it on another production box.
I connected to crsprod1 via RDC last night and installed sqlbackup4, changed the sqlbackup agent service account, scheduled the job, and run a test run. It would come back with the following error:
Executed as user: DOM\SQLSERVER_DBA2. SQL Backup job failed with exit code: 0 SQL error code: 17 [SQLSTATE 42000] (Error 50000). The step failed.
In additiona, I am unable to manually backup any database via the sqlbackup UI but can do it via t-sql (backup database [db] to disk ...)
Could someone provide a solution? the backup sql code looks like this
DECLARE @exitcode int DECLARE @sqlerrorcode int exec master..sqlbackup N'-SQL "BACKUP DATABASES [master, msdb, model] TO DISK = ''F:\sqlbackups\sys_db_full\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', COPYTO = ''\\crsbk01\SQLBackups\crscentdbtst\sys_db_full\'', PASSWORD = ''<ENCRYPTEDPASSWORD>REMOVED</ENCRYPTEDPASSWORD>'', KEYSIZE = 256, ERASEFILES = 2, COMPRESSION = 3, THREADS = 1"', @exitcode OUTPUT, @sqlerrorcode OUTPUT IF (@exitcode <>0) OR (@sqlerrorcode <> 0) BEGIN RAISERROR ('SQL Backup job failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode) END