Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
New Contributor
wayneski
Posts: 3
Registered: ‎04-21-2010
My Device: n/a
My Carrier: n/a

BES 5.0 H/A is dedicated SQL Server required

Hi,

 

I am looking to deploy BES 5.0 for 500 users in a H/A setup with 2 BES servers.

 

Do you have to deploy the configuration database on a separate SQL Server mirror ?

 

Or can you use SQL 2008 express locally on each BES server to do this to avoid deploying additional servers ?

 

 im not sure if mirroring will work on SQL express for this

 

Thanks

 

Wayne

Please use plain text.
Guru III
knottyrope
Posts: 30,096
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 5.0 H/A is dedicated SQL Server required

Depends on your needs.

 

You can have a remote SQL express server and still have HA.

A mirror would be better but not needed unless your SLA demands it.

 

Having a SQL express on each BES will not do what you are looking for unless you can mirror them. Separate databases will make each BES an individual, you need a common database that is shared.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.
New Contributor
wayneski
Posts: 3
Registered: ‎04-21-2010
My Device: n/a
My Carrier: n/a

Re: BES 5.0 H/A is dedicated SQL Server required

Hi,

 

we would need the SQL Database to be H/A also

 

so we couldn't use mirroring with SQL Express on each BES server ?

 

We would have to use SQL Server standard instead correct ?

 

Thanks

 

Wayne

Please use plain text.
Guru III
knottyrope
Posts: 30,096
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 5.0 H/A is dedicated SQL Server required

IIRC the only thing with express you can do is witness.

For mirrioring you need full version of SQL.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.
New Contributor
wayneski
Posts: 3
Registered: ‎04-21-2010
My Device: n/a
My Carrier: n/a

Re: BES 5.0 H/A is dedicated SQL Server required

ok great

 

Last question :-)

 

 

So is there any problem with installing SQL 2008 Standard on each BES server and doing the mirroring there ?

 

thanks

Wayne

Please use plain text.
New Member
jrb218
Posts: 1
Registered: ‎05-03-2010
My Device: World Edition
My Carrier: Verizon

Re: BES 5.0 H/A is dedicated SQL Server required

You may want to check out SteelWorks from SteelCloud. They have an appliance solution that lets you do HA with just 2 servers.

Please use plain text.