How to find Last Restore Date od SQL Server database?
Few developers asked me how to find the last time a database was restored using T-SQL. I have formed the following query using MSDB..RestoreHistory table.
SELECT *
FROM MSDB..RestoreHistory WITH (nolock)
WHERE destination_database_name = 'DatabaseName'
ORDER BY restore_date DESC
Best Power BI Course helps you master data visualization, reporting, and business intelligence. It’s perfect for professionals who want to turn raw data into meaningful insights
ReplyDelete