Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Daily DATABASE BACKUP JOB IS FAILED Expand / Collapse
Author
Message
Posted Monday, March 3, 2014 7:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 8:14 AM
Points: 6, Visits: 322
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
Post #1546914
Posted Monday, March 3, 2014 7:13 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
Step 1: Check the SQL error log and job history and see why it failed.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1546920
Posted Monday, March 3, 2014 7:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 8:14 AM
Points: 6, Visits: 322
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.
Post #1546930
Posted Monday, March 3, 2014 7:51 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
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 2008, MVP
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

Post #1546932
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse