Post reply

Restore History?

  • June 1, 2006 at 2:32 pm

    #113212

    OK, I'm writing a procedure that looks in the some system tables and creates restore statements from the last backup. Long story short, I don't really have a way to verify that the restore was successful. Does SQL Server keep a history of restores as opposed to backups?

    Any help would be great, even if there is another way to programatically verify the restore happeded without using system tables (if one even exists for restores)

    Thanks!

  • June 2, 2006 at 7:35 am

    #641421

    Adam

    You could create a job that writes a row to a table and runs whenever the text "Database backed up: Database MyDB" appears in the error log.

    John

  • June 2, 2006 at 12:22 pm

    #641512

    MSDB..restorehistory is a system table that records the History of restores.


    Glenn Henson

  • June 2, 2006 at 1:37 pm

    #641522

    Thanks, why I did not find that on my own is beyond me, right in front of my face. Anyway, thanks a bunch for the help! that's exactly what I need

  • June 2, 2006 at 4:14 pm

    #641537

    Here's a handy link no DBA should be without:

    http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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