Someone Deleted a Table

  • Ninja's_RGR'us

    SSC Guru

    Points: 294069

    tfifield (9/21/2011)


    Remi,

    I can think of a couple of ways to do this using file names or dates. I'm curious as to how you do it?

    Todd Fifield

    Something like this (forgot the exact naming convention now that everything is scripted)

    FULL-DBName-2011-09-21 0500.bak

    LOG-DBName-2011-09-21 1215.bak

    then get the list of files in that folder. Decide which backup to use and what PIT to stopat and figure out when to stop based on the date.

  • tfifield

    SSCrazy Eights

    Points: 9655

    Ninja's_RGR'us (9/21/2011)


    tfifield (9/21/2011)


    Remi,

    I can think of a couple of ways to do this using file names or dates. I'm curious as to how you do it?

    Todd Fifield

    Something like this (forgot the exact naming convention now that everything is scripted)

    FULL-DBName-2011-09-21 0500.bak

    LOG-DBName-2011-09-21 1215.bak

    then get the list of files in that folder. Decide which backup to use and what PIT to stopat and figure out when to stop based on the date.

    Remi,

    Thanks. I'll stick it in my tool chest.

    Todd Fifield

Viewing 2 posts - 16 through 17 (of 17 total)

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