Post reply

Someone Deleted a Table

  • September 21, 2011 at 4:47 pm

    #1384884

    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.

  • September 24, 2011 at 10:58 am

    #1386116

    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 16 (of 16 total)

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