Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Determining a database's completed restore date and time... Expand / Collapse
Author
Message
Posted Tuesday, December 11, 2012 10:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, July 26, 2014 8:57 AM
Points: 7,081, Visits: 12,575
Hemant.R (12/10/2012)
hi ,

whenever you restore any database ,that activity related info got stored in

restorehistory table of msdb

plz check with using this

select destination_database_name,USER_NAME,restore_date from restorehistory order by restore_date desc


if ,i m wrong plz tell me.

Please re-read the first sentence of the original post.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1395225
Posted Tuesday, December 11, 2012 10:41 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 25, 2014 11:43 AM
Points: 436, Visits: 2,262
We're running SQL 2005 Enterprise Edition. We restore a backup of a 100gb db every day in the early morning hours.
The scheduled job starts at 3:45am each day; the value I see in RESTORE_DATE is 3:45:04am (+-3 seconds).

This db does NOT get restored in 4 seconds; it takes about an hour.



Cursors are useful if you don't know SQL
Post #1395241
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse