>Is there a SP that will return information about when the last time a particular database was backed up?
>(if the answer is yes what is the name of the SP? <s>)
>
>Thanks,
>Einar

select max(backup_finish_date) from msdb..backupset where type = 'D' and database_name = N'databasename'