Restore corrupt database Exchange 2010 DPM 2012

Posted on 2014-02-03
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

762 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