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: Z10
Carrier: Vodafone (UK)
Posts: 463
Post Thanks: 21
Thanked 3 Times in 3 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: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,132
Post Thanks: 352
Thanked 352 Times in 329 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
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Passport, Z30, Z10 and Q10
Online  
Old 07-24-2013, 08:29 AM   #3 (permalink)
Kul
Talking BlackBerry Encyclopedia
 
Kul's Avatar
 
Join Date: May 2005
Location: London, England.
Model: Z10
Carrier: Vodafone (UK)
Posts: 463
Post Thanks: 21
Thanked 3 Times in 3 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: Z10
Carrier: Vodafone (UK)
Posts: 463
Post Thanks: 21
Thanked 3 Times in 3 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: Z10
Carrier: Vodafone (UK)
Posts: 463
Post Thanks: 21
Thanked 3 Times in 3 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

Comfort Products 60-5800T Commodore II Oversize Leather Chair with Adjustable
$301.27
Comfort Products 60-5800T Commodore II Oversize Leather Chair with Adjustable pictureNew RARE** Holden Racing Team Holden VE Commodore Bnwt Will Metal Watch Fashion
$17.55
New RARE** Holden Racing Team Holden VE Commodore Bnwt Will Metal Watch Fashion pictureWindsor Commodore CMD Self-Propelled Carpet Extractor Cleaner w/ Fastraction
$750.0
Windsor Commodore CMD Self-Propelled Carpet Extractor Cleaner w/ Fastraction picture17" Holt Commodore Floor Scrubber/sander
$95.99
178 x CM 8164 DRAM 64kx1 164 4864 IC Apple IIe Commodore 64 Oric IBM PC Soviet Era
$4.95
8 x CM 8164 DRAM 64kx1 164 4864 IC Apple IIe Commodore 64 Oric IBM PC Soviet Era picture






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