Finding When Backup Was Restored in SQL Server
Hello to everyone,
In this article, I will talk about how to find the time when the backup was restored in SQL Server.
In some cases in SQL Server, you may want to know when the backup was restored.
You can easily do this using the code below.
DECLARE @DB sysname = 'Northwind'; SELECT * FROM msdb.dbo.restorehistory WHERE destination_database_name = @DB;
When you run the above code, you will get a result similar to the one below.
As you can see it was found when the backup was restored.
Good luck to everyone in business and life.