BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-29-2008, 05:33 AM   #1 (permalink)
New Member
 
Join Date: Oct 2005
Model: 8700
Carrier: vodafone uk
Posts: 12
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Simple BES/SQL Question

Please Login to Remove!

Hi,

We recently centralised the BES SQL database on seperate SQL cluster boxes. If these boxes were to be taken down (even for 30 mins or so) what would the impact be on the BES?

Would users still be able to send\recieve during this period?

Also, when the SQL cluster comes back online, would any BES services require any action (ie restart etc) or would the reconnection between the BES and SQL be transparent?

Many thanks folks!
Offline  
Old 05-29-2008, 07:12 AM   #2 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 237 Times in 219 Posts
Default

BES will continue to function without SQL connectivity for a period of time.
How long depends on the size of your environment, and how "busy" it is.
You'll lose some statistics during the SQL outage, but mail will still flow.

According to RIM employees we've heard speak at WES, there have been instances where large environments have been without SQL connectivity for up to 6 hours.
Your milage may vary, but I think you'd probably be OK with a 30 minute outage.

When SQL comes back up, BES should just simply reconnect on its own and pick up where it left off. At most, you might just ant to restart the Blackberry services on the BES if anything quirky arises when SQL comes back.
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 05-29-2008, 07:21 AM   #3 (permalink)
New Member
 
Join Date: Oct 2005
Model: 8700
Carrier: vodafone uk
Posts: 12
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

penguin3107 - many thanks - thats the answer I was hoping for. Hopefully as you suggest, the BES should just reconnect when SQL comes back online.

Thanks!
Offline  
Old 05-29-2008, 07:45 AM   #4 (permalink)
Knows Where the Search Button Is
 
dhoff4's Avatar
 
Join Date: Dec 2007
Location: Atlanta, GA
Model: 8320
PIN: N/A
Carrier: T-mobile
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just make sure that you don't try to shut down BES while SQL is unavailable. If you do this, it will start trying to write all sorts of stuff to SQL, which creates more fun when BES restarts next time. Most people seem to be able to get an hour or so without any issues.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.