capnhector (11/7/2012)
if your just looking for a report of backups you can query msdb.dbo.backupset which contains allot of information
select top 10 b.database_name, b.backup_start_date, b.backup_finish_datefrom msdb.dbo.backupset b
with a join to sys.databases you can eliminate system databases if you dont care about them or can get more detailed info about the databases. no need to run through the error log with a cursor.
I was able to pull that information already. But wanted to identify the status of a database backup (failed/succeeded) which doesnt get logged in msdb.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams