• Saga... (12/28/2011)


    Hi Team,

    I need to find out the backup failure history.....

    Till date how many backup are failed in sql server how can I find that...

    please help...

    Could be wrong here but if I get what you're after your backup should be hopefully setup as a maintaince task/SQL Agent Job.

    If you right click on the task itself and select "View History" it will give you the information you require i.e. Date, Plan Name,Duration, Error Number & Error Message (plus more). You can then investigate that error message in full.

    Hopefully that's what you were trying to get as an answer - if not expand more.