Find the database restore history
When ever we restored database from the backup file the sql server stored information on msdb database table restorehistory.
SELECT restore_date ,destination_database_name
FROM msdb..RestoreHistory
ORDER BY restore_date DESC
SELECT restore_date ,destination_database_name
FROM msdb..RestoreHistory
ORDER BY restore_date DESC
No comments:
Post a Comment