Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
albertoerice@yahoo.es
Starting Member
1 Post |
 Posted - 2009-01-08 : 12:11:56
|
| Hi all,We need to know how to see in a database the last restore we have done. We have lost our previous backup and we are trying to research what happened with the database.It is a possibility that the restore of the database was COMPLETE. (We first delete the old database, and then we restore it with the same name). How can we know the date of the last restore in the server?. Thanks in advance, |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-08 : 12:23:13
|
| Look at MSDB..restorehistory.. |
 |
|
|
|
|
|
How to see the date of the last restore on the db?