time based recovery
-
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.
-
You 'll need your db in bulk or full recovery mode.
check out http://www.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
-
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