Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

BES Database queries

Hi

We running BES 4.1.7 with a SQL 2005 database. We have about 5 BES servers connected to that one DB.

The SQL team need to take the DB server offline for a period of time over the weekend for some maintenance.

Can anyone tell me what effect this will have on BES? As far as I know, the BES DB holds ALL the information relating to BES. But, assuming I'm not making any changes to the actual infra such as adding users etc, will the lack of DB connectivity affect users in any way? How does it work in terms of RefID etc which I assume are stored in the DB too?
0
bruce_77
Asked:
bruce_77
  • 5
  • 4
1 Solution
 
Shekhar2coolCommented:
Well, if the DB is not available, BB Services will go in stopped Mode. Complete BB functionality will stop.

0
 
bruce_77Author Commented:
Your saying the BES services will actually stop on the server?
0
 
Mike SullivanDirectorCommented:
The BlackBerry services will stall rather than stop. It would be better practice to take them offline gracefully until the work was completed and bring them back online afterwards.
0
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!

 
bruce_77Author Commented:
Right so the services would actually still be running, but we would lose BES functionality?
0
 
Mike SullivanDirectorCommented:
Correct. There would be evidence in the BES log files to show that there are faults, but you would need to be able to decipher them.
0
 
bruce_77Author Commented:
Does anyone know how this works in terms of RefID?

As I understand it, each message that BES sends is assigned a RefID. These RefID's are held in the BES database (not sure where else they can be held).

So if a BES server is unable to write information regarding RefID's to anywhere (i.e. the DB is down), does this mean that BES can't send these messages? Or are  can be stored in RAM or similar until an eventual time out? Which would imply that once the timeout hits, we're in even greater trouble due to sync issues.
0
 
Mike SullivanDirectorCommented:
This information is stored in a hidden folder in the user's mailbox.
0
 
bruce_77Author Commented:
Ah ok - so what info would BES lack that would cause the services to 'fail'?
0
 
Mike SullivanDirectorCommented:
Configuration information for the users such as the peer-to-peer cryptogrpahic key are held int he SQL database along with the PIN of the handheld. If the Agent can't read this, it will try 10 times then give up for 24 hours.
0
 
Mike SullivanDirectorCommented:
How did you get on with this, Bruce?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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