|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Dell PowerEdge Servers
|
|
#1
January 26th, 2004, 03:55 PM
|
||||
|
||||
Restore Database Date
In my environment we restore production copies of the database over existing dev databases to simulate prod environment. I would like to check the last restore date before I do that just in case someone else did 5 minutes ago. I was under the assumption that the "Date Created" was this date but I just restored one and check but the time is not correct.
Could someone confirm for me on how to check when a databse was last restored? scratching my head....
__________________
mr... mike.rusaw@realpage.com RalPage, Inc. "I have made this letter longer than usual, only because I have not had the time to make it shorter." - Blaise Paschal Last edited by mrusaw : January 28th, 2004 at 09:56 AM.
|
|
#2
January 28th, 2004, 09:52 AM
|
|||
|
|||
|
You could check in the logs? Not sure of any other easier way...
|
|
#3
January 28th, 2004, 10:06 AM
|
||||
|
||||
|
Duh! As soon as I read your message the freaking light bulbs started flashing!
Yes, the log gives a detailed time of the last restore (as well as other good stuff...) Quote:
I was in developer mode and stuck looking at the properties of the database rather than being in DBA mode and looking in the logs.  Thnx
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Restore Database Date |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
