[KapsBB]

I am doing HA for Exchange 2010 and also BES v5.0.4.27. The DAG on Exchange is nearly complete and I also need to setup BES in HA in a different site. It seems that the designs I have looked at usually have SQL installed separately from BES. For our installation we have a single BES server in NY with SQL 2005 running on that server. Will this work in a HA setup? I haven't started the install yet. It seems that you point the new install to the current SQL database and it will detect an active BES already and give you the option to setup a standby BES, but I would like to confirm how this is supposed to work before starting the install.

Which brings me to the next question. Since this is multi-site, does that SQL database need to be setup with clustering or anything, or will BES replicate the data to the second site? Obviously if our NY datacenter goes down, that SQL database won't be available in CHI. So I am wondering if when you install the second BES, does it setup its own SQL database and replicate? If not, what are my options for setting up a multi-site HA BES?

I attached a diagram of what is being setup.

[knottyrope]

you need to cluster SQL and have a dedicated SQL server for it then once that is done move your BES database to it and re point BES to it.

[KapsBB]

Are there any good support documents for setting up the SQL clustering for BES? Just want to know what all the requirements are and what versions are supported.

[knottyrope]

This is the best fix for your BES server. - BlackBerry Support Community Forums

I have many helpful links there

[KapsBB]

So from what I found out, SQL is really used for the BAS administration. It does not need to be on a separate server, but it needs to be mirrored when using a multi-site configuration.

[knottyrope]

SQL is used for a whole lot more than just that.