none
continuious data protection for sql 2008 r2 with dpm 2012 sp1

Answers

  • HI,

    DPM protects SQL databases that are in full recovery mode in a cdb fashion without you needing to do anything special.  When you create a protection group and add SQL DB's, keep the default option to perform synchronizations every 15 minutes.  This will schedule incremental backups every 15 minutes, so you will get 96 recovery points in a 24 hour period.   DPM will allow you to recovery from any of those recovery points and you have the choice to replay the logs to bring the db into a clean state, or you can replay the logs manually up to a particular transaction.  For the time period between last incremental backup (Synchronization) and the next incremental backup, DPM give the option to restore to LATEST - which restores the DB and logs for the last successful recovery point (which will less than 15 minutes old) back to the original location, replays the restored logs, then replays the last log still on the SQL Server that DPM did not yet backup.  This brings that database back into the state of the last transaction prior to the DB failure. 


    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.

    Thursday, July 04, 2013 8:18 PM

All replies

  • HI,

    DPM protects SQL databases that are in full recovery mode in a cdb fashion without you needing to do anything special.  When you create a protection group and add SQL DB's, keep the default option to perform synchronizations every 15 minutes.  This will schedule incremental backups every 15 minutes, so you will get 96 recovery points in a 24 hour period.   DPM will allow you to recovery from any of those recovery points and you have the choice to replay the logs to bring the db into a clean state, or you can replay the logs manually up to a particular transaction.  For the time period between last incremental backup (Synchronization) and the next incremental backup, DPM give the option to restore to LATEST - which restores the DB and logs for the last successful recovery point (which will less than 15 minutes old) back to the original location, replays the restored logs, then replays the last log still on the SQL Server that DPM did not yet backup.  This brings that database back into the state of the last transaction prior to the DB failure. 


    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.

    Thursday, July 04, 2013 8:18 PM
  • Thanks Mike for the clarification.

    Although I've configured in the same manner, but i was told to know whether we can have more granular level synchronization period which will be less than 15 min.

    If that can be done through PS scripting then kindly help me with that.


    Abdul Razak

    Friday, July 05, 2013 9:23 AM
  • Hi,

    It really sounds like you need more of a high availability solution like SQL mirroring.   yes, you can force DPM to take manual (ad-hoc) recovery points using power shell, but with diminishing returns.  Like how long does it take to make the incremental backup, and with a limit of 448 recovery points, the retention period gets reduced incrementally as the frequency of the RP's increases.


    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.


    Friday, July 05, 2013 2:59 PM
  • Hello Mike,

    Do you have any resources for creating PS Script for DPM. 

    I want to configure interval of 10 min for sql backup.



    Abdul Razak

    Saturday, July 13, 2013 9:16 PM