• Hanshi One more question on this...

    Consider below scenario

    Day 1

    Full Backup

    Log backup every 3 hours

    (I have 1 Full backup & 4 log backup)

    Day 2

    Full Backup

    Log backup every 3 hours

    (I have 1 Full backup & 4 log backup)

    Day 3

    Full Backup

    Log backup every 3 hours

    (I have 1 Full backup & 4 log backup)

    Day 4 - If i was told that on day 2 their was a record delete which they want to recover then...

    What will i do is..

    Restore Full Backup of Day 2 on some testing enviornment

    Restore Log backup one by one till i get the data..

    Is this correct???

    ************************************
    Every Dog has a Tail !!!!! :-D