March 3, 2014 at 7:05 am
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
March 3, 2014 at 7:13 am
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
March 3, 2014 at 7:46 am
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.
March 3, 2014 at 7:51 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply