Restore corrupt database Exchange 2010 DPM 2012

Posted on 2014-02-03
Last Modified: 2014-03-11
I have an Exchange 2010 DAG environment. Backups are performed with DPM 2012. I want to simulate/test a recovery of a corrupt database in our lab environment.

All of the articles i have found refer to a single mailbox restore...which means the original DB is up and running without error. The database is restore to a recovery database, then the mailbox in question is extracted and restored to the existing database.

This is not what i want to do. I want to restore an entire failed database in my DAG environment. None of the articles, including the microsoft DPM 2012 administrator guide, cover the topic of restoring the failed database.

if anyone had done this, or knows of a complete doc i would appreciate it.
Question by:citsadmins
  • 3
  • 2

Expert Comment

ID: 39829696
Basic First Wild Guess Answer - We have DAG and use DPM also. It's my understanding that in a disaster recovery, since the remote Exchange Database will be offline, the general concept is that we will go to the location with the replicated Database, and simply mount it. It is possible this will fall to me in our organization, and that is what I plan to do.

Author Comment

ID: 39867271
thanks for your response dalberson. If the active copy of a DB becomes corrupted on one of the servers in your DAG, it will automatically mount one of the passive copies of that DB on one of the other servers based on your activation preference. Then you can reseed the failed copy of the DB right from the management console.

What i am trying to simulate is a total loss or corruption of all copies of one DB where the only way to recover would be a full restore from DPM.

I think all i need to do is check "this database can be overwritten by a restore" in the DB properties page/maintenance tab in the EMC. And then run the restore thru the DPM console. Very simple and straightforward...unless its not...which is what I was hoping to get some feedback on before I run thru the simulation.

Doesn't look like anyone other than you and me has any further input. I am going to run thru it with the instructions i have and see how it comes out. I will post a follow up with my results and any other issues/resolutions, as well as a step by step for anyone else needing this in the future.

thanks for you input...I'll get back to you.

Expert Comment

ID: 39870955
Cool. I look forward to hearing about the outcome.

Accepted Solution

citsadmins earned 0 total points
ID: 39910004
Follow the link below for the recovery steps in DPM.  It was very simple. (how unusual for Microsoft)

Only thing I did different in order to simulate a total DB failure, was to remove the DB copies on two of my DAG servers, then  I deleted/renamed some files from the mailbox store for the DB in question. This left me with one copy of the DB, which was unrecognizable to exchange.

I restored the DB on that server and then recreated the copies on the other two servers.

How to recover a database to its original location

   1.  On the server to which the database will be recovered, configure the target database to allow it to be overwritten by the recovered data.

      a. Go to Organization Configuration/Mailbox/Database management tab.

     b. Open properties for DB in question

     c. On Maintenance tab check the box for "this Database can be overwritten by a restore"

   2.  In DPM Administrator Console, click Recovery on the navigation bar.

   3. Using the browse functionality, select the database to recover.

   4. On the Recovery time menu, select Latest.
         ( You must select the most recent recovery point to recover the storage group to its original location)

   5.  In the Actions pane, click Recover.

   6.  The Recovery Wizard starts. The wizard options will vary depending on the version of Exchange.

    7. On the Review recovery selection page, click Next.

    8. Select Recover to original Exchange Server location, and then click Next.

    9. On the Specify recovery options page, you can select Send an e-mail when this recovery completes.

   10. On the Summary page, review the recovery settings and then click Recover.

   11. After recovery completes open the EMC on one of the exchange servers, go to Organization configuration/mailbox/database management tab and highlight the DB in question on the upper screen. click anywhere in the database copies tab in the lower screen and hit F5 to refresh. You should see one copy of the database, mounted and active on the server. (if not you will need to do further research to figure out the issue)

   12. Copy the database to the two other DAG member servers. (also known as seeding the database)

          a. make sure target servers have the same HD volume configuration/drive letter.

          b. on the EMC (same location as step 11) right click the DB and select "add mailbox database copy"

          c. Browse to the server node you want to copy to

         d. Select the activation preference

          e. click Okay/finish

13. After copy process completes refresh the database copy screen again. you should now see a second copy of the database located on the second server. it will be inactive and copy status should be "healthy".

14. repeat steps 12 and 13 to create another copy on the 3rd server.

that completes the process.

Author Closing Comment

ID: 39919980
No other input was received from other users. The process i have laid out here solved my problem completely

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
coldfusion create csv file  error 31 126
SCOM - Create Tasks 1 54
SCCM Microsoft Report 2 48
Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now