Monday, December 10, 2012 12:26 PM
Can any one suggest me.
My backup plans are Every Monday and Friday 4:00 AM Full Backup and everyday 8:00 AM Differential backup and
Every One hour Transaction Log Backups .
my DB is corrupted on Wednesday morning 10: 30 AM and i recovered the database till Wednesday morning 10:00 AM with the following manner.
step 1: Monday morning(4:00 AM) Full Backup restored.
step 2 : Wednesday morning(8:00AM) Differential Backup restored
step 3 : Wednesday morning up to 10:00 AM Transaction Backup restored
Now my doubt is how can I get data between 10:00 AM to 10:30 AM ...? Please give me valuable suggestion for recovering critical situation.
Regard's | Ramu | DBA |
Tuesday, December 11, 2012 12:00 AMModerator
DPM does not perform Differentail backups. For databases, we have express full backups and incremental synchronization backups for logs. Assuming you take one Express full backup per day and perform hourly incremental synchs, if you want to restore to include the latest logs after the last incremental, you simply choose the option called "LATEST" and dpm will restore the last full backup, all the incremental logs. Those logs including the log file that has not yet been backed up and still sitting on the server will be replayed and take you up to the last transaction before the DB went down. So in ensence it's a single restore from a DPM GUI perspective.
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.