07-24-2013, 05:36 AM
Talking BlackBerry Encyclopedia
Join Date: May 2005
Location: London, England.
Carrier: Vodafone (UK)
Post Thanks: 20
Thanked 2 Times in 2 Posts
| | 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 ?