There are some time when we as a DBA wants to find out some historical data, such as backup restore history.
This is very easy to find from MSBD.
select restore_date, destination_database_name from msdb..restorehistory
If you need more details you know what to do.
No comments:
Post a Comment