Roger Abram
Hall of Fame
Points: 3683
More actions
January 22, 2010 at 9:19 am
#218503
We have a database that we use for testing that gets refreshed with a copy of another database (production) from time to time.
Is there an easy way for me to find when the test database was last restored (overwritten)?
Thank you.
Rog
murthykalyani
SSCarpal Tunnel
Points: 4500
January 22, 2010 at 11:27 am
#1107482
You can get the details from restorehistory table in msdb database or from error log, or application log.
January 22, 2010 at 12:36 pm
#1107512
Thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply