Post reply

Date DB was last restored?

  • July 11, 2006 at 11:57 am

    #61289

    I have a developer that restores a DB to a seperate server as needed for developing, and he was wondering if there is a way to see when the last time a DB has been restored.   I can see when a DB is CREATED, however, I am looking for the last time it was restored from a backup.

    TIA

    Cory

    -- Cory

  • July 11, 2006 at 12:05 pm

    #648556

    SELECT Restore_Date

    FROM MSDB..RestoreHistory

    WHERE Destination_Database_Name = 'YourDBName'

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 11, 2006 at 12:24 pm

    #648562

    PERFECT!  I feared it would be that easy...

    -- Cory

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

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