I want to deploy BES COnfiguration Database Mirroring in Prod

Posted on 2011-02-24
Medium Priority
Last Modified: 2012-05-11

I already have the following:

BAS Server 01 and 02
BES Primary
BES Standby

Connecting to SQL 2005 Database

It's all working fine.

Now I want to introduce Database mirroring....

What would be the precautions I should be aware of?

Thanx in Advance
Question by:Amir4u
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
  • 2

Author Comment

ID: 34971907
Also, this is out test environment. In our Prod we have two SQL servers but they are not configured as mirror, they are clustered.

So whats are Pros and Cons of BES confi databases as "MIrrored" and as "Clustered" ?
LVL 25

Accepted Solution

RobMobility earned 2000 total points
ID: 34978230

Suggest you include a Witness server to automate failover - i.e. you will need 3 servers running SQL.

1. Backup your database first!
2. Make sure the database isn't configured as a 'Simple' database
3. Backup the database and transaction log
4. Restore the database and transaction log but set them to Restore with No Recovery)
5. Create SQL Service accounts in AD (if using windows authentication) and change the service to run under these - grant them admin rights to the SQL
6. When mirroring the databases, use the above service accounts during the mirroring process.

Other than that, it works, however, you may need to manually add some registry keys to the servers in order for them to 'realise' mirroring is enabled. The alternative is to enable SQL mirroring within the BAS service and then force an update to the other servers - this should create the registry keys.


LVL 25

Expert Comment

ID: 34978235

With regards to Clustering, RIM DO NOT support this - I have never tried it for this reason and whilst it might work, it would affect any support agreement you have with RIM and/or a Telco.



Author Closing Comment

ID: 34979274
it's good

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

When a user’s mailbox is first created and his Blackberry account enabled how do we provision the device and what happens in the background? Stage 1 – Activation The user of the BlackBerry device types the email address and activation password i…
I felt secure communicating on the BBM... Till some time back!! It was probably the fact that the BBM messages do not travel over the internet was making me feel 'secure' about it, or was it the fact that BBM only works on a BlackBerry Devices a…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

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