BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 07-24-2013, 05:36 AM   #1
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: Z10
Carrier: Vodafone (UK)
Posts: 467
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
knottyrope
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
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
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter

Rocking the Motion with out lotion.
Offline  
Old 07-24-2013, 08:29 AM   #3
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: Z10
Carrier: Vodafone (UK)
Posts: 467
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
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: Z10
Carrier: Vodafone (UK)
Posts: 467
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
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: Z10
Carrier: Vodafone (UK)
Posts: 467
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


Digital Ohmmeter LCD Audio Impedance Test Meter Speaker Voice Resistor System picture

Digital Ohmmeter LCD Audio Impedance Test Meter Speaker Voice Resistor System

$62.99



Audio Impedance Tester Portable CATIII Test Ranges 20/200/2000 Resistance Meter picture

Audio Impedance Tester Portable CATIII Test Ranges 20/200/2000 Resistance Meter

$72.24



AVO Biddle Bite  Battery Impedance Test Equipment Tester Megger picture

AVO Biddle Bite Battery Impedance Test Equipment Tester Megger

$99.99



Impedance Meter Gold Line Model ZM1P Goldline picture

Impedance Meter Gold Line Model ZM1P Goldline

$375.00



TekBox TBOH01 - 5uH DC Line Impedance Stabilisation Network LISN picture

TekBox TBOH01 - 5uH DC Line Impedance Stabilisation Network LISN

$249.00



TOA ZM-104 Impedance Meter Handheld Battery Operated Japan  with Case & Leads picture

TOA ZM-104 Impedance Meter Handheld Battery Operated Japan with Case & Leads

$129.99







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