Viewing Database Restore History in SQL Server
In this article, I will try to give information about viewing database restore history in SQL Server.
In SQL Server, you may want to view the database restore history in some cases.
You can easily do this using the code below.
SELECT [restore_date] ,[destination_database_name] ,[user_name] ,[backup_set_id] ,[restore_type] ,[replace] ,[recovery] ,[restart] FROM [msdb].[dbo].[restorehistory]
Good luck to everyone in business and life.