Solved

I want to deploy BES COnfiguration Database Mirroring in Prod

Posted on 2011-02-24
4
635 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

679 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