Post reply

time based recovery

  • December 7, 2005 at 5:16 am

    #112832

    Can you please send me links/information on how to configure sqlserver backup's so that the DB recovery can be made to a specified timestamp.

    Thanks in Advance.

  • December 7, 2005 at 8:08 am

    #608177

    You 'll need your db in bulk or full recovery mode.

    check out http://qa.sqlservercentral.com/columnists/kKellenberger/restoringtoapointintime.asp

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • December 8, 2005 at 2:48 am

    #608351

    To elaborate further:

    1. Set your databases to be in Full/Bulk recovery mode(ideally Full)

    2. Create a maintenance plan which takes regular Full and transaction log backups(example - daily night full backup and then transaction log backups each hour) depending on your Recovery Point objective.

    3. lets say you want to recover till 11.30 AM .Now if you want to restore a database to a ponit in time:

    restore full backup with no recovery

    restore all transaction log backups with no recovery till 11 AM

    restore the last transaction log backup (of 12 PM) with Stop At 11:30 option and with recovery.

    To see the syntaxes of commands you can see Books Online (BOL)

    Hope this helps.

    Anurag

Viewing 3 posts - 1 through 2 (of 2 total)

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