Declare @ArchiveNum Int 
Declare @Arch_Temp Table(ArchiveNo Int, Date DateTime, LogFileSize BigInt)
Declare @Err_temp Table(LogDate DateTime, ProcessInfo NVarchar(30), Text Nvarchar(MAX)) 
Insert Into @Arch_Temp 
	Execute xp_enumerrorlogs 
Declare Arch_Cursor Cursor LOCAL STATIC FORWARD_ONLY 
For 
Select ArchiveNo From @Arch_Temp 
Open Arch_Cursor 
Fetch NEXT From Arch_Cursor Into @ArchiveNum 
While(@@FETCH_STATUS = 0) 
	Begin
		 Insert Into @Err_temp 
			EXEC sys.xp_readerrorlog @ArchiveNum 
			
		 Fetch NEXT From Arch_Cursor Into @ArchiveNum 
	End 
Close Arch_Cursor 
DeAllocate Arch_Cursor 
Select * From @Err_temp Where ProcessInfo = 'Backup'

select top 10 b.database_name, b.backup_start_date, b.backup_finish_date
  from msdb.dbo.backupset b