opc.three (10/5/2011)
george sibbald (10/4/2011)
declare @dbname sysname
set @dbname = db_name()
print @dbname
select backup_start_date,backup_finish_date,backup_size/1024 as 'size in MB'
from msdb..backupset
where database_name = @dbname and type = 'D'
I have just one tweak. backup_size is in bytes so the label should say 'size in KB'.
oops, cheers.
If you want size in MB
declare @dbname sysname
set @dbname = db_name()
print @dbname
select backup_start_date,backup_finish_date,backup_size,backup_size/1048576 as 'size in MB'
from msdb..backupset
where database_name = @dbname and type = 'D'
---------------------------------------------------------------------