Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Need Restoration history of a DB

    Hello

    You can use this query to see the history.

    USE MSDB

    GO

    SELECT CONVERT(VARCHAR(59),restore_date,113) AS 'Restore Date'

    ,destination_database_name AS Restored_DB_Name

    ,USER_NAME AS 'User'

    ,restore_type as Restore_Type

    ,replace as Replace

    ,destination_phys_name as 'Destination Files'

    FROM restorehistory...

Viewing post 1 (of 1 total)