Find the Database Restore History
On SQL Instance, at times we should know what DB’s got restored on specific instance or want to know when specific DB got restored. Below query will help to achieve that.
SELECT * FROM MSDB..RESTOREHISTORY ORDER BY RESTORE_DATE DESC
Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates
KTEXPERTS is always active on below social media platforms.
Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform