Monday, 3 March 2014

DataBase Restore History - SQL Server

SELECT MAX(restore_date) AS LastRestore
      ,COUNT(*) AS CountRestores
      ,destination_database_name
FROM msdb.dbo.restorehistory
GROUP BY destination_database_name

From this link 
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)