How can we help you today? How can we help you today?

Backup error assistance request

I'm using SQLBackup 4 to perform daily differential backups. SQLBackup generated this code as the job step:

DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-SQL "BACKUP DATABASES [*] TO DISK = ''F:\SQLBackups\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', DIFFERENTIAL, ERASEFILES_ATSTART = 30, COMPRESSION = 1, THREADS = 1"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF (@exitcode <>0) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END

I'm getting an error message back that the job does not run, yet there are daily files created for each of the databases. The error message is:

Executed as user: NT AUTHORITY\SYSTEM. SQL Backup job failrd with exitcode: 1010 SQL error code: 3024[SQLSTATE 42000](Error 50000). The step failed.

Can anyone shed any light on what the error codes mean - possibly suggest a correction?
spraguetr
0

Comments

1 comment

Sort by
  • spraguetr
    Looks like I made the wrong selection. All databases were included in the differential backup, but you can't do that with MASTER.

    I've excluded the system databases from the daily differential backup and created a new daily full backup for the system databases. Will continue to monitor. :oops:
    spraguetr
    0

Add comment

Please sign in to leave a comment.