BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-24-2013, 05:36 AM   #1 (permalink)
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: 9300
Carrier: Vodafone (UK)
Posts: 437
Post Thanks: 18
Thanked 2 Times in 2 Posts
Default SQL High Availability on BES10.1

Please Login to Remove!

Under BES5.0.3, we have BES HA setup which protects us against node failure but to provide HA for the SQL DB, I confgured SQL mirroring for the BESMgmt database and when the SQL serverA goes down, the Mirrored SQL serverB bring the mirrored copy online. I have to reinstall BES on the passive node to point to the SQL ServerB Database for service to resume. and all has been working fine and when the SQL serverA is brought online, reinstall BES pointing to the SQL ServerA Database and all is ok.

Under BES10.1, would this work ? as SRP looks at the MAC address of the machine and the licensing model is different - I am not sure, but going to test out...

How do you guys protect against SQL Server failure ?
Offline  
Old 07-24-2013, 07:31 AM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,564
Post Thanks: 256
Thanked 260 Times in 246 Posts
Default Re: SQL High Availability on BES10.1

I run SQL in clustered mode on server 2012 with nightly database to file backups.

for us this is enough as the database does knot hold as much as BES 5 did
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Offline  
Old 07-24-2013, 08:29 AM   #3 (permalink)
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: 9300
Carrier: Vodafone (UK)
Posts: 437
Post Thanks: 18
Thanked 2 Times in 2 Posts
Default Re: SQL High Availability on BES10.1

ok , but assuming you dont have SQL in cluster mode but instead have SQL Mirroring enabled, would the way I have been doing work ?

Last edited by Kul : 07-24-2013 at 08:48 AM.
Offline  
Old 07-24-2013, 08:36 AM   #4 (permalink)
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: 9300
Carrier: Vodafone (UK)
Posts: 437
Post Thanks: 18
Thanked 2 Times in 2 Posts
Default Re: SQL High Availability on BES10.1

I am actually not sure SQL Mirroring can be done now, as I have just noticed that the "Database Mirroring" tab on the Server Configuration Panel of BES10 doesnt exist anymore !! - is present on BES5.0.3
Offline  
Old 07-24-2013, 10:22 AM   #5 (permalink)
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: 9300
Carrier: Vodafone (UK)
Posts: 437
Post Thanks: 18
Thanked 2 Times in 2 Posts
Default Re: SQL High Availability on BES10.1

Can be done I guess ... KB34373
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

Similar Threads for: SQL High Availability on BES10.1
Thread Thread Starter Forum Replies Last Post
Fresh Install 5.0 Remote SQL Error dvine RIM Software 0 10-12-2009 04:44 AM
BES upgrade to 4.1.6 Horsebox BES Admin Corner 3 08-05-2008 06:27 PM
Perform a cutover to another BlackBerry Enterprise Server in IBM Lotus Domino hdawg BES Admin Corner 3 04-25-2008 09:47 AM
DB Upgrade Failed. Error Executing SQL statement SimonMac BES Admin Corner 18 09-27-2007 08:03 AM





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