解决方法
这将列出服务器上每个数据库的所有“最新”还原：
WITH LastRestores AS
(
SELECT
DatabaseName = [d].[name],[d].[create_date],[d].[compatibility_level],[d].[collation_name],r.*,RowNum = ROW_NUMBER() OVER (PARTITION BY d.Name ORDER BY r.[restore_date] DESC)
FROM master.sys.databases d
LEFT OUTER JOIN msdb.dbo.[restorehistory] r ON r.[destination_database_name] = d.Name
)
SELECT *
FROM [LastRestores]
WHERE [RowNum] = 1
