Post reply

Database refresh date

  • November 5, 2010 at 2:30 pm

    #149294

    I want to know when our Dev database was last refreshed as of production.

    it there any script tht will tell me when the database was last refreshed.

  • November 5, 2010 at 3:19 pm

    #1247356

    query table msdb..restorehistory.

    ---------------------------------------------------------------------

  • November 8, 2010 at 7:47 am

    #1247664

    Thank you very much

  • November 8, 2010 at 7:55 am

    #1247667

    Depends. What do you mean by 'refresh'?

    If you mean restored from backup, George's query will work. If you mean something else, it won't.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply