Solved

Mounting a Passive copy of a database in a DAG if the Active copy fails

Posted on 2013-01-30
2
1,093 Views
Last Modified: 2013-02-01
I have been searching around for a documented procedure for preparing a passive copy of a database in a DAG when the Active database fails. When all is well, its easy to activate a passive copy  but what happens if the server crashes or the database unexpectedly becomes corrupt and dismounts.Most likely the Passive copy will failed/suspended or failed /resynchronizing state and may not mount if all the logs have not been copied over to play back.
0
Comment
Question by:osiexchange
[X]
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
2 Comments
 
LVL 63

Assisted Solution

by:Simon Butler (Sembee)
Simon Butler (Sembee) earned 125 total points
ID: 38839819
As long as the databases are healthy, and the FSW is available then it should just mount. If you are going in to a suspended/unmounted state then something is wrong with your DAG operation. Many times I have just rebooted the active server and the passive takes over without any interaction from me.

Simon.
0
 
LVL 15

Accepted Solution

by:
GreatVargas earned 125 total points
ID: 38840148
As Sembee said the behavior is to automatically get the passive copy mounted.. meaning that server will take over the database copy if the server were it's mounted fails.. that's the expected behavior  on a healthy DAG.

also probably you should be aware of two things:

1- Lagges copies
some customers like to have lagged copies to prevent a corruption to replicate over to several database copies (this is a huge discussion topic). just to let you know that if you have a lagged copy of 1 day for example.. meaning that the logs are replicated from the active copy to the lagged copy 1 day after being created.. you need that 1 day of logs to replicate before the other server takes over.. so the bottom line is, dont use lagged copies unless you're under a scenario were you really need to (i.e low bandwith links between the sites)

2- Database Activation Policy
you can prevent database copies from being activated automatically by changing the activation policy at the mailbox server level
http://technet.microsoft.com/en-us/library/dd298046(v=exchg.141).aspx

hope that helps
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Utilizing an array to gracefully append to a list of EmailAddresses
Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

710 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