Solved

I want to deploy BES COnfiguration Database Mirroring in Prod

Posted on 2011-02-24
4
634 Views
Last Modified: 2012-05-11
Hi,

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
0
Comment
Question by:Amir4u
  • 2
  • 2
4 Comments
 

Author Comment

by:Amir4u
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" ?
0
 
LVL 25

Accepted Solution

by:
RobMobility earned 500 total points
ID: 34978230
Hi,

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.

Regards,


RobMobility.
0
 
LVL 25

Expert Comment

by:RobMobility
ID: 34978235
Hi,

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.

Regards,


RobMobility.
0
 

Author Closing Comment

by:Amir4u
ID: 34979274
it's good
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

This article will help those of you having problems with the Nextel Blackberry 8350i.  Recent Software updates cause the problems issues described below, and this article will help you revert back to the older software. As we know, Nextel has alw…
Last night I received a weird phone call, from a number I didn’t recognized.  I answered it and no one responded back so I hung up.   Didn’t look at my phone until my husband said “Your phone is doing something weird”.   I had what I’ll consider the…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

759 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

18 Experts available now in Live!

Get 1:1 Help Now