查询SQL Server 2005数据库中数据库的最后备份日期
- 作者: 羊羊疯
- 来源: 51数据库
- 2022-08-17
SELECT a.Name AS DatabaseName,COALESCE(CONVERT(VARCHAR(12),MAX(b.backup_finish_date),101),'Not Yet Taken') AS LastBackUpDate,COALESCE(CONVERT(VARCHAR(12),MAX(b.user_name),101),'NA') AS TakenBy FROM sys.sysdatabases a LEFT OUTER JOIN msdb.dbo.backupset b ON b.database_name=a.name GROUP BY a.Name ORDER BY a.Name
推荐阅读
