Tava (12/28/2011)
Saga... (12/28/2011)
Thanks TAVA for reply.Actually I was seeking information for the failed backups in SQL Server. (Those backups which are not successful. We can notify it in error log, job history. Is there any other way??)
I'm not to sure other than Job History, As i have never needed to look at other alternatives. You can have alerts created if you're using "Maintenance Plans" to notify you upon an unsuccessful backup but this would be for new backups not previously failed ones priori.
Just to add, not sure if this covers Unsuccessful backups or not but saw this article on MSDN website. http://msdn.microsoft.com/en-us/library/ms188653.aspx "A complete history of all SQL Server backup and restore operations on a server instance is stored in the msdb database"