All posts by phil

MSSQL Database Restore History simple query

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 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.

UPDATE:

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!