Home Forums SQL Server 2005 Backups Determining a database's completed restore date and time... RE: Determining a database's completed restore date and time...

  • December 11, 2012 at 10:05 am

    #1567532

    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