none
DPM 2012 Database Recovery Options RRS feed

  • Question

  • Good Morning,

         This is a two part question.

    1. If I want to run a DR test to recover a complete DB (not just the mailbox). What is the easiest way to complete this? We have 1 active, 2 copies in our DAG. So every time you cut down the info store and rename the DB, it just mounts on the copy.

    2. Secondly, when backing up a primary DPM server with a secondary DPM server, do i just need to make sure and protect the SQL DB?

    Thanks,

    MKC

    Tuesday, August 27, 2013 2:04 PM

Answers

  • Hi,

    To do just a "test" restore of a mailbox database, you will need to use the options 2 or 3 below if you don't want to effect production.

    Recovering Exchange 2010
    http://technet.microsoft.com/en-us/library/ff399247.aspx


    -Recovering Exchange Server 2010 Mailbox Databases
    Changing the status of a database from active to passive or vice versa may affect the recovery process. If the database is passive, DPM cannot perform a Volume Shadow Copy Service (VSS) recovery.

    -Recovering to the active database is the same as recovering to an Exchange Server 2010 stand-alone node. The Exchange Server administrator must synchronize the passive copy from the recovered active copy by running the Resume-MailboxDatabaeCopy cmdlet on the Exchange server. You can recover a database only on the node that was protected.

    DPM supports the following five types of recovery for Exchange Server 2010 mailbox databases:

    1.Recover the database to its original location. Overwrite the existing copy of the database.

    2.Recover the database to an alternate database. Restore to another database on an Exchange Server.

    3.Recover to an Exchange Recovery database. Recover to an Exchange Recovery database instead of a standard mailbox database.


    4.Recover to network location. Copy the database to a network folder.


    5.Copy to tape. Create an on-tape copy of the database.

    NOTE: DPM does not support recovering mailbox databases to passive databases. While recovering to the original database or to an alternate database, the target database on which the recovery is being performed should not be passive.

     

    Yes, it's very important to backup the primary DPM Servers DPMDB if you ever need to recover it. As per the following TechNet article: http://technet.microsoft.com/en-us/library/jj244597.aspx

    At a minimum, you should select the databases, the \Program Files\Microsoft System Center 2012\DPM\DPM\Config folder, and the \Program Files\Microsoft System Center 2012\DPM\Scripting folder.


    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.

    Wednesday, August 28, 2013 3:52 PM
    Moderator
  • Hi,

    If you were not using a secondary DPM server, then yes, I would recommend using either long term tape protection on the DPM Server, or use 3rd party tape backup solution to make backup of DPM replica.  However, with a secondary DPM server in place - the secondary DPM is protecting the primary data sources, so there is no need to have a separate backup of the replica.  One of the option on the secondary DPM server is to restore to Primary DPM Server replica, so after a DR - you rebuild the primary, restore latest DB, then you can re-seed the primary replica from the secondary dpm server while maintaining current protection using the secondary.


    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.

    • Marked as answer by mkcj84 Thursday, August 29, 2013 4:35 PM
    Thursday, August 29, 2013 3:13 PM
    Moderator

All replies

  • Hi,

    To do just a "test" restore of a mailbox database, you will need to use the options 2 or 3 below if you don't want to effect production.

    Recovering Exchange 2010
    http://technet.microsoft.com/en-us/library/ff399247.aspx


    -Recovering Exchange Server 2010 Mailbox Databases
    Changing the status of a database from active to passive or vice versa may affect the recovery process. If the database is passive, DPM cannot perform a Volume Shadow Copy Service (VSS) recovery.

    -Recovering to the active database is the same as recovering to an Exchange Server 2010 stand-alone node. The Exchange Server administrator must synchronize the passive copy from the recovered active copy by running the Resume-MailboxDatabaeCopy cmdlet on the Exchange server. You can recover a database only on the node that was protected.

    DPM supports the following five types of recovery for Exchange Server 2010 mailbox databases:

    1.Recover the database to its original location. Overwrite the existing copy of the database.

    2.Recover the database to an alternate database. Restore to another database on an Exchange Server.

    3.Recover to an Exchange Recovery database. Recover to an Exchange Recovery database instead of a standard mailbox database.


    4.Recover to network location. Copy the database to a network folder.


    5.Copy to tape. Create an on-tape copy of the database.

    NOTE: DPM does not support recovering mailbox databases to passive databases. While recovering to the original database or to an alternate database, the target database on which the recovery is being performed should not be passive.

     

    Yes, it's very important to backup the primary DPM Servers DPMDB if you ever need to recover it. As per the following TechNet article: http://technet.microsoft.com/en-us/library/jj244597.aspx

    At a minimum, you should select the databases, the \Program Files\Microsoft System Center 2012\DPM\DPM\Config folder, and the \Program Files\Microsoft System Center 2012\DPM\Scripting folder.


    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.

    Wednesday, August 28, 2013 3:52 PM
    Moderator
  • Thank You!
    Wednesday, August 28, 2013 6:32 PM
  • Concerning the answer below, Other than  the DPMDB, Config, and Scripting. Should I also protect the replica's? I am really just trying to understand the exact things needed to be backed up by the second DPM for seamless switchover for Exchange 2010. Thanks

    Yes, it's very important to backup the primary DPM Servers DPMDB if you ever need to recover it. As per the following TechNet article: http://technet.microsoft.com/en-us/library/jj244597.aspx

    At a minimum, you should select the databases, the \Program Files\Microsoft System Center 2012\DPM\DPM\Config folder, and the \Program Files\Microsoft System Center 2012\DPM\Scripting folder.

    Thursday, August 29, 2013 1:03 PM
  • Hi,

    If you were not using a secondary DPM server, then yes, I would recommend using either long term tape protection on the DPM Server, or use 3rd party tape backup solution to make backup of DPM replica.  However, with a secondary DPM server in place - the secondary DPM is protecting the primary data sources, so there is no need to have a separate backup of the replica.  One of the option on the secondary DPM server is to restore to Primary DPM Server replica, so after a DR - you rebuild the primary, restore latest DB, then you can re-seed the primary replica from the secondary dpm server while maintaining current protection using the secondary.


    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.

    • Marked as answer by mkcj84 Thursday, August 29, 2013 4:35 PM
    Thursday, August 29, 2013 3:13 PM
    Moderator
  • Thanks. 

    So in summary on the DPM that protects the DPM, I should only backup the following to seamlessly switchover in case of loss of the Primary DPM.

    DPM Database

    Config

    Scripting

    And I should not backup

    Replicas

    Or anything associated with the Exchange database (ie. we wouldnt have any protection groups on the secondary server for the DB's)

    Thursday, August 29, 2013 4:39 PM
  • HI,

    That is incorrect, You would need to have secondary protection enabled for the exchange DB's by making PG's on the secondary.

    <snip>
    However, with a secondary DPM server in place - the secondary DPM is protecting the primary data sources, so there is no need to have a separate backup of the replica.
    >snip<


    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, August 29, 2013 4:56 PM
    Moderator
  • Gotcha, I think we had that part confused. So the Secondary needs to have the same protection groups, and to be making backups on the same schedule as the primary?

    but, we also need the DPMMB DB, Config, and Scripting?

    Thursday, August 29, 2013 5:51 PM
  • Hi,

    Yes, the Secondary Protection will inherit the same backup schedule from the primary, but you can use a different retention period on the secondary.

    This may be a useful blog for you to review:

    http://blogs.technet.com/b/dpm/archive/2012/05/09/secondary-protection-and-exchange-2010-dag-node-protection-in-system-center-data-protection-manager.aspx


    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, August 29, 2013 6:05 PM
    Moderator
  • So in summary, we really need to be backing up the second copy on the secondary DPM server. That would mean having the same amount of space available for both DPM servers?

    Tuesday, September 3, 2013 11:28 AM