Post reply

database Restore hystory LOG

  • January 15, 2014 at 2:27 am

    #288332

    Hi folks,

    i was told to send the restore DB log report .

    i know we can fetch this through MSDB(sysdb)..RestoreHistory table.

    Where can we check the log for backup or restore info or any mail alert system when ever DB created/backup/restore

    Thanks in advance

  • January 15, 2014 at 2:32 am

    #1680151

    Backup history is in MSDB, in the table BackupHistory, restore history is in MSDB in the table RestoreHistory.

    Mailed notifications you'd have to implement yourself afaik.

    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

  • January 15, 2014 at 3:07 am

    #1680161

    Thanks for the quick response

    Please let me know any link or screenshots/procedure for Mailed notifications implementation

    Thanks in advance

  • January 15, 2014 at 3:31 am

    #1680168

    jamessdba (1/15/2014)

    Hi folks,

    i was told to send the restore DB log report .

    i know we can fetch this through MSDB(sysdb)..RestoreHistory table.

    Where can we check the log for backup or restore info or any mail alert system when ever DB created/backup/restore

    Thanks in advance

    Backup and restore operations can also be found in the SQL server log and the Windows app event log

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • January 15, 2014 at 4:50 am

    #1680197

    Thanks i found this info under log

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log...

  • January 15, 2014 at 5:30 am

    #1680215

    jamessdba (1/15/2014)

    Thanks i found this info under log

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log...

    😉

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 5 (of 5 total)

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