I agree with Rich & Don. You've outgrown MSDE long ago. You'd want to have the SQL database/server in the same data center. If it's in a remote data center, then you would ideally want to have a redundant network path to get to it. In case of an outage, the BES can operate ok without being able to access the DB for a short time - though you wouldn't be able to add/delete/modify users until the DB came back online.
We're using MS SQL Server 2005 Standard Edition - SP2. The server is in the same data center as our 3 BES (4.1.6 MR5) & 3 Exchange 2007 SP1 servers. 1800 BlackBerry's Get the DBA's to buy off on it, and it's really easy. RIM doesn't tend to make a lot of changes to the DB except in the major releases... 4.0, 4.1 & 5.0. Sometimes a service pack will have a DB modification, though it's rare (imho). Always read the release notes and if there's a change to the DB, get the DBA's involved. See these two kb's for the supported versions of SQL Microsoft SQL Server software versions supported by BlackBerry Enterprise Server software http://www.blackberry.com/btsc/KB15682 What is the compatibility of BlackBerry Enterprise Server software versions 4.0 and 4.1 with Microsoft SQL Server 2005 http://www.blackberry.com/btsc/KB11158 kind regards, Trevor From: [email protected] [mailto:[email protected]] On Behalf Of Moller, Doreen Sent: Thursday, July 16, 2009 8:21 AM To: A list for BES Admin's to discuss issues, etc. Subject: [Bes-admins] SQL Database Hi Everyone, Do you know if it is desirable to have the SQL database on a separate server or is it best to have the SQL database local. Our Company deploys SQL Server farms. Our BES has almost 900 users and is on MSDE. We need to migrate to full blown SQL. We are running BES 4.1.6 for MS Exchange. Also what version of SQL are supported? Trying to plan a strategy crashed last weekend and I think we have outgrown MSDE. As usual everyone's help is greatly appreciated. Thanks! Doreen Moller Lead Analyst, Infrastructure - Mobility Schering-Plough Corp 908-473-3627 (Summit) [email protected]<mailto:[email protected]> ********************************************************************* This message and any attachments are solely for the intended recipient. If you are not the intended recipient, disclosure, copying, use or distribution of the information included in this message is prohibited -- Please immediately and permanently delete. </PRE><p style="font-family:arial;color:grey" style="font-size:13px">This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.</p><PRE>
_______________________________________________ Bes-Admins mailing list [email protected] http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins ---------------------------------
