Daily DATABASE BACKUP JOB IS FAILED

  • Hi Sir,

    my DB DatabaseBackup - USER_DATABASES - DIFF this is my failed database backup name.

    this is backjob is everyday failed.but my drive free space available. could any one please tell me how to resolve user database backup job and what are the steps i am checking and how to resolve this issue.

    Thank you

  • Step 1: Check the SQL error log and job history and see why it failed.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • i checked sql server error log file and job history but it is showing(the job failed the job was invoked by seadule 10(back job name) the last step to run was step 1(back up job filed name)

    could you please tell me how to resolve.

  • Check the SQL Server error log for details on why the backup failed (the error log doesn't show that job failed message). Check the details of the job failures (ie the job step failure message) for the details on why the step failed.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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