Usually you would like to know last time a database was restored. This is very handy script to show you the details. 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 […]
Category Archives: SQL Server
Turn on flag – DBCC TRACEON 1222 Start monitoring the SQL Server Event Logs.