试试: select top 1 database_name, name from msdb.dbo.backupset where type = 'D' and database_name = 'xxx' order by backup_finish_date desc
多谢 CN_SQL Helper在你的基础上做了下修改 --------------------------------------------------------- select top 1 TB1.*,TB2.logical_device_name,TB2.physical_device_name from msdb.dbo.backupset as TB1,msdb.dbo.backupmediafamily as TB2 where TB1.media_set_id=TB2.media_set_id and type = 'D' and database_name = 'DBName' order by TB1.backup_finish_date desc ---------------------------------------------------------结贴
select top 1
database_name,
name
from msdb.dbo.backupset
where type = 'D'
and database_name = 'xxx'
order by backup_finish_date desc
---------------------------------------------------------
select top 1 TB1.*,TB2.logical_device_name,TB2.physical_device_name from msdb.dbo.backupset as TB1,msdb.dbo.backupmediafamily as TB2
where TB1.media_set_id=TB2.media_set_id and type = 'D' and database_name = 'DBName'
order by TB1.backup_finish_date desc
---------------------------------------------------------结贴