After reading several posts on the internet for discovering database restoration history, I realized that most were way over complicating what you can do in SQL 20008R2 and up.<\/p>\n
This is the easiest method for me:<\/p>\n
use msdb
\nselect * from restorehistory<\/p>\n
And that is pretty much it.<\/p>\n
However, I do have one server that is making me scratch my head. The restorehistory table is empty, but the logs clearly show that I had several restores in the last 3 months. Hmmm.<\/p>\n
UPDATE:<\/p>\n
OK I feel rather stupid about this. Of course the restore history is empty, I am cleaning it up with part of my maintenance plan!<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
After reading several posts on the internet for discovering database restoration history, I realized that most were way over complicating what you can do in SQL 20008R2 and up. This is the easiest method for me: use msdb select * from restorehistory And that is pretty much it. However, I do have one server that … Continue reading MSSQL Database Restore History simple query<\/span>