• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1052
  • Last Modified:

BES Database failover

Hello

Running BES 4.1.7 with SQL 2005 for a database. We have about 10 BES servers. The SQL database (SQL1) also has a replication partner, SQL2.

The SQL team want to test the fail over of services from SQL1 to SQL2.

Theoritically, there should not be any downtime for BES.

There are still some queries I had though -

1. When the database is failed over, how can I check that BES is still running as usual? What sort of tests would be good (apart from the Test SQL connection one)

2. If - for whatever reason, the SQL team said that the fail over would result in 2 hour outage. What would be best? Leave BES server running, but queueing messages, or just shut them down?
0
smith1974
Asked:
smith1974
  • 3
1 Solution
 
radcaesarCommented:
In Case of SQL, You can chaec the Services. In case of BES, I am blank and some Blackberry guys will help on it.
0
 
Shekhar2coolCommented:
Well, the first thing you should care about is the downtime.

Once they fail-over, check the BB Services, try sending IT policy to any user if that works, then BES is fine. Also you can try to pull data "Asset Summary Data" for any user and if that gives the output, again it means BES is fine.

If Sql team asks for 2 hours downtime, then you should give them the time you think Users wont bother about, probably late night. Let the BES running, and after the fail over is done check as above.
0
 
RobMobilityCommented:
Hi,

Have you considered upgrading to BES 5.0.x? This supports database mirroring OOB.

Regards,


RobMobility.
0
 
RobMobilityCommented:
Hi,

I don't believe that BES 4.1.x natively supports any form of Database failover - only products such as Neverfail and DoubleTake are supported as partner products.

BES 5 introduced High Availability using SQL Mirroring (2005 SP3 and later) - SQL Clustering is not supported by RIM.

Regards,


RobMobility.
0
 
RobMobilityCommented:
RIM DOES NOT support Database Mirroring nor Clustering on BES 4.1, only mirroring on 5.x (non Express version).
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now