Backup operation/job fail information

Hi,
I would like to know about the internal information regarding sql backup
operation.
I want to monitor the Backup operation in all version of sql server. I am
able to get all the information from the msdb database but i'll not find any
information regarding backup fails.
Suppose i want to monitor a database in a certain time interval and i want
to collect data for successful backup and failed backup.
How do i collect these information through my code?
Should i read and parse Error log file or sql provide some system table or
stored procedure for this?
Or there are any api provided by sql?
I'm waiting for positive response.
Thanks n Regards,
Nikhil Kumar JainHi
Yes , Error Log should give you an info.
"Nikhil Kumar Jain" <NikhilKumarJain@.discussions.microsoft.com> wrote in
message news:B0074C50-F6B0-4370-B95A-8A8C7E7DB0AD@.microsoft.com...
> Hi,
> I would like to know about the internal information regarding sql backup
> operation.
> I want to monitor the Backup operation in all version of sql server. I am
> able to get all the information from the msdb database but i'll not find
> any
> information regarding backup fails.
> Suppose i want to monitor a database in a certain time interval and i want
> to collect data for successful backup and failed backup.
> How do i collect these information through my code?
> Should i read and parse Error log file or sql provide some system table or
> stored procedure for this?
> Or there are any api provided by sql?
> I'm waiting for positive response.
> Thanks n Regards,
> Nikhil Kumar Jain