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