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