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
Posted Tuesday, December 11, 2012 10:05 AM



Group: General Forum Members
Last Login: 2 days ago @ 10:58 PM
Points: 7,288, Visits: 13,140
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


Group: General Forum Members
Last Login: 2 days ago @ 2:15 PM
Points: 440, Visits: 2,429
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