Thank you so much. This is the information I was looking for. I will check with RIM to see if they support Log shipping. And I did want a transparent cutover. I'm glad to know mail flow will not be affected. Good to know not to restart services. I really appreciate your quick response.!!!
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Rich Fleming Sent: Thursday, October 22, 2009 02:38 PM To: A list for BES Admin's to discuss issues, etc. Subject: Re: [Bes-admins] Mirroring the BES 5.0 Database using SQL 2005 I've never liked log shipping, and I don't think that it's supported by RIM. You might want to check on that. I don't believe you'll have an invisible "hands-off" failover with that setup either. If the database goes down, there will be minimal impact to users. You can run BES without a DB connection for several hours (depending on how busy your BES is and how many users you have. Mileage may vary) Mail flow will not be affected. Keep in mind... you CANNOT reboot BES or restart any BES services if the database is not running. From: [email protected] [mailto:[email protected]] On Behalf Of Moller, Doreen Sent: Thursday, October 22, 2009 2:33 PM To: A list for BES Admin's to discuss issues, etc. Subject: Re: [Bes-admins] Mirroring the BES 5.0 Database using SQL 2005 My SQL team suggested setting ours up to use Log shipping. Do you think that is sufficient? This way the data is not replicated real time but you can set that often. I am thinking that will probably be okay as our data doesn't really change frequently. I just don't know if with log shipping if the cutover is transparent, trying to find out. Also if the database were to go down, that is the impact to the users? Can they continue to send/receive email? thanks! ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Rich Fleming Sent: Thursday, October 22, 2009 02:30 PM To: A list for BES Admin's to discuss issues, etc. Subject: Re: [Bes-admins] Mirroring the BES 5.0 Database using SQL 2005 Yes, I've done it and we're running a mirrored SQL 2005 database (BES 5.0 MR2) in production. From: [email protected] [mailto:[email protected]] On Behalf Of Moller, Doreen Sent: Thursday, October 22, 2009 2:28 PM To: A list for BES Admin's to discuss issues, etc. Subject: [Bes-admins] Mirroring the BES 5.0 Database using SQL 2005 Hi - Does anyone have any experience with this? 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. ********************************************************************* 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 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 [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 ---------------------------------
