Dump Database

Make a SELECT in the backupset table:

SELECT b.database_name AS base,
       CASE b.type
            WHEN 'D' THEN 'Completo'
            WHEN 'L' THEN 'Log'
            WHEN 'I' THEN 'Diferencial'
            ELSE 'Outro'
        END tipo,
        CONVERT(VARCHAR, b.backup_finish_date, 103) + ' ' + CONVERT(VARCHAR, b.backup_finish_date, 108) AS fim
  FROM msdb.dbo.backupset b
 ORDER BY b.database_name, b.backup_finish_date DESC

  

backupset

     

Contains one row for each backup set. A backup set contains the backup of a single successful backup operation.