SQL Server Performance Forum – Threads Archive
how can I find out when the last restore occured
Hi, I am looking at the MSDB tables such as restorehistory and restorefile, but they are empty… I know I just restored the master database, and want to make sure it really got restored. How can I find out? Thanksselect * from dbo.restorehistory in msdb —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com
restorehistory includes information about the restore of the master database also. So if this table is empty, it means that there is a problem with your restore. Roji. P. Thomas
http://toponewithties.blogspot.com
]]>