Determne if SQL Server database restored

Question

I need to check if a content database for SharePoint has been restored (as some point in the past).

Are there any log file entries - in SharePoint or SQL Server - I can check for to determine this? Or any other approach (apart from asking someone)?

Answer 1

You could try connecting to it. You won't be able to if its in the middle of a restore.

Answer 2

If you want to know when was the last time a database was restored, look into msdb.dbo.restorehistory.

If you want to know if a current restore operation is complete, check the database status in sys.databases.