SQL Agent log Backup job failed

  • Hi,

    SQL agent log backup job is failing intermittently in one of our Prod server,

    In job history i can not see the exact issue why it has failing...i can see below

    @CleanupTime = 120, @Compress = 'Y', @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @checksum = 'N', @BlockSize = NULL, @BufferCount = NULL, @MaxTransfer... The step failed.

    where can i look for the exact issue, appreciate any responses.

    Thanks

    Sunny

  • G Sunny (12/5/2016)


    Hi,

    SQL agent log backup job is failing intermittently in one of our Prod server,

    In job history i can not see the exact issue why it has failing...i can see below

    @CleanupTime = 120, @Compress = 'Y', @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @checksum = 'N', @BlockSize = NULL, @BufferCount = NULL, @MaxTransfer... The step failed.

    where can i look for the exact issue, appreciate any responses.

    Thanks

    Sunny

    You can check the job history table and look at the message there -

    select *

    from msdb.dbo.sysjobhistory

    where job_id = 'YourJobID'

    You can also add an output file if things are getting truncated. Go to the Properties for the job, select the edit for the step that is failing in the job, go to Advanced and that is where you can put in an output file and path. Make sure it's a directory that SQL Agent has permissions to, like the default JOBS directory that gets setup on install...whatever. Just make sure it has permissions.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply