Tuesday, December 21, 2010

Query to list all the backups

use msdb
go
select f.file_size/(1024*1024) 'file_size',s.backup_size/(1024*1024) 'backup_size',s.backup_finish_date,s.database_name,f.logical_name from
backupset s inner join backupfile f on s.backup_set_id=f.backup_set_id
where s.database_name='rar' and s.type='D'
order by s.backup_finish_date desc

No comments:

Post a Comment