Backup & Restore

Find When A Database Was Last Restored

This simple script will show you when databases were restored. It helps you find the restore history of any or all databases.

select
user_name
, convert(char, restore_date, 9) as 'when restored'
, restore_date
, destination_database_name
, restore_type
, replace
, recovery
from
msdb..restorehistory
order by
restore_date desc
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s