Thank you so much for the detailed response. I am going to get our DBA's involved and get cracking on this upgrade. Its hard to get things to happen fast in my company so this has been a bit procrastinated. But we crashed last week so now there is no time to play.
________________________________ From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of Vance, Trevor K Sent: Thursday, July 16, 2009 12:39 PM To: A list for BES Admin's to discuss issues, etc. Subject: Re: [Bes-admins] SQL Database 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: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] 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) doreen.mol...@spcorp.com <mailto:doreen.mol...@spcorp.com> ********************************************************************* 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. 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. ********************************************************************* 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.
_______________________________________________ Bes-Admins mailing list Bes-Admins@dataoutages.com http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins ---------------------------------