Simply execute on your instance to receive the most recent info about any database restores that have taken place on the server.
SET NOCOUNT ON SELECT destination_database_name ,bmf.physical_device_name ,restore_date FROM msdb.dbo.restorehistory INNER JOIN msdb.dbo.backupset as bs ON bs.backup_set_id = msdb.dbo.restorehistory.backup_set_id INNER JOIN msdb.dbo.backupmediafamily as bmf ON bs.media_set_id = bmf.media_set_id WHERE restore_history_id IN ( SELECT MAX(restore_history_id) FROM msdb.dbo.restorehistory WHERE restore_type = 'D' AND destination_database_name IN ( SELECT DISTINCT destination_database_name FROM msdb.dbo.restorehistory ) GROUP BY destination_database_name ) ORDER BY restore_date DESC SET NOCOUNT OFF
Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.
2018-04-19
1,128 reads
This script will perfrom following tasks :
1. BackUp DB
2. Restore DB from BackUp File
3. Restore DB from DB
4. Create a new DB from Existing Db
It takes care of all the possible failures during these operations, while done manually.
2017-01-11 (first published: 2017-01-09)
1,591 reads
Perform automated database restores and check the integrity of your backup files
2014-08-11
5,105 reads
This article describes a way to automatically restore multiple database backups from a directory.
2014-04-21
5,939 reads
When you are running a backup or a restore, this script gives you an estimate of completion time.
2013-06-14 (first published: 2013-05-30)
1,563 reads
