Originally Posted by emminentt
Right now I am having an dilemma on weather to take the SQL server off the BES.
Currently I have:
4.0 BES (plus SPs)
SQL server locally running on machine.
In your opinion what are the pros and cons of having SQL server running locally on the server or off?
Any suggestions would be great. Thanks ahead of time.
You should separate your BlackBerry Enterprise Server software from your SQL Server. That way, if your BlackBerry Enterprise Server crashes, you still have the BlackBerry database and you can install the BlackBerry Enterprise Server on another machine and point the installation back to the database. This would be seamless to your users. In the event that the SQL server crashes, you can have a backup SQL server and restore the database to this backup server. Once restored, you can point your BlackBerry Enterprise Servers to this backup SQL server with minimal downtime for your users.