Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
How to Recover Complete data

Unanswered How to Recover Complete data

  • Monday, December 10, 2012 12:26 PM
     
     
    Sign In to Vote
    0

     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 |


     

All Replies

  • Tuesday, December 11, 2012 12:00 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    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.