Revision: 13247
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at April 16, 2009 00:09 by pollusb
Initial Code
-- D = Database.
-- I = Database Differential.
-- L = Log.
-- F = File or Filegroup.
select serverproperty('ServerName') server_name, database_name, type, max(backup_finish_date) backup_date
from msdb..backupset
group by serverproperty('ServerName'),database_name, type
order by 2,3
Initial URL
Initial Description
In a migration scenario, you may need to take a backup and a differential later to split the transfer over time. But to make it work, there shouldn't be any other full backup in between. This will help you check the last full backup date. Of course, you could use it for a lot of other reason.
Initial Title
Last Backup Date for All databases
Initial Tags
backup
Initial Language
SQL