Post reply

SQL Server 2000 Database Restoration

  • November 17, 2008 at 1:02 am

    #196088

    Is there any way to check when a database was last restored in SQL Server 2000 through query analyzer.

  • November 17, 2008 at 1:06 am

    #899196

    Hi,

    Table "Restorehistory" in MSDB holds this information.

    [font="Verdana"]Renuka__[/font]

  • November 17, 2008 at 9:15 am

    #899383

    above poster is right

    USE msdb

    SELECT TOP 100 *

    FROM RESTOREHISTORY WITH (NOLOCK)

    --WHERE destination_database_name IN ('XXX')

    ORDER BY restore_date DESC

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

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

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