Comments
3 comments
-
Details of the error ought to be logged in the SQL Backup Agent log file. The default folder where the log files are stored is <system drive>:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.
Look for a file generated during the time of the backup, that contains error 790. -
I checked in that location but I do not have any log files associated with this error.
-
Could you pls send me the 12 log files that were generated for that backup? Thanks.
Add comment
Please sign in to leave a comment.
The version of SQL Backup is 5.1.0.2781.
The backup files are created and look to be the correct size. There is only one Application Event Log error for the SQL Agent Job (Job code below) and there are no SQL Log for an error, just successful execution of the full backups. I am wondering why is the exitcode 790 when it is completing the backups successfully?
The code for the job is below. It backs up to our tape backup server which I removed the name and replaced with <SERVERNAME> and the folder with the originating server name with <SERVERFOLDER>
--This statement backs up all databases
declare @exitcode int
declare @sqlerrorcode int
exec master..sqlbackup N'-SQL "BACKUP DATABASES [*] TO DISK = ''\\<SERVERNAME>\backup\<SERVERFOLDER>\<database>_RG.bak'' WITH DESCRIPTION = ''<AUTO>'', INIT, VERIFY, COMPRESSION = 1"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF (@exitcode <> 0) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup step failed: exit code %d, SQL error code: %d',
16, 1, @exitcode, @sqlerrorcode)
END