--列出czgl所有备份的记录
SELECT backup_set_id,case type when 'D' then '完全' when 'I' then '差异' end type,convert(numeric(7,2),backup_size/(1024*1024*1.0)) size,backup_start_date,physical_device_name
FROM msdb..backupset A,msdb..backupmediafamily B
where A.media_set_id=B.media_set_id AND type!='F'
and database_name='czgl' order by backup_start_date