select
BackupDate = convert(varchar(10),backup_start_date, 111)
,SizeInGigs=floor( backup_size/1024000000) --轉(zhuǎn)換大小為 GB單位
from msdb..backupset
where
database_name = 'DatabaseName' --你要查看的數(shù)據(jù)庫名稱，請?zhí)鎿Q
and type = 'd'
order by
backup_start_date desc