Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a full backup job for my database that runs once daily, I see it posted daily in the folder that it should go to, but when I check the "View History" for this job in SQL Server Agent, there are red X's which tells me that it didn't run successfuly...

The opposite is happening for the Differential job that I see running successfully in the job history and posted successfully too in the destination folder.

I'm planning to restore both of these copies to see if they contain current updated data, but regardless, if I see the full .bak file in my folder, shouldn't the job show that it ran successfuly with a green checkmark?

share|improve this question
2  
Do you have enough disk space for the FULL backup to succeed ? –  Kin Jan 27 at 17:25
3  
You see red x's, ok, next step is to dig into the step history and see what the actual error message is. –  Aaron Bertrand Jan 27 at 17:27
    
@Kin Yes as its a new server that I just upgraded to and it has 447GB free of 546GB –  Shayma Ahmad Jan 27 at 18:38
    
@AaronBertrand The only way I know how to see the step history in further details is to "Export" and save the current displayed info that I see from the "View Job History"--> "Log File Viewer" to a .log file : –  Shayma Ahmad Jan 27 at 18:41
1  
And do you find the full backup files where you expect to find them? Are you able to restore them on a test system? If so, then I suspect something else is going wrong in the maintenance plan, after the backups are complete. Maybe you have shrink or other optimization jobs, cleanup activities, who knows... –  Aaron Bertrand Jan 27 at 20:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.