In our case, the DB move went very smoothly. However, as Michael and Rich have both asserted to, the new SQL server needs to have the BES scheme updated in its master tables or something like that. To get around that we simply allowed BES to create a new database on the destination SQL server, then swapped the configuration to use our live BES DB again.
Good luck. Richard PS Should be no appreciable downtime from a user perspective. From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of Gargano, Steve Sent: 14 December 2009 13:41 To: 'A list for BES Admin's to discuss issues, etc.' Subject: [Bes-admins] SQL Database Move For those of you who have moved their sql database before, was it a hard thing to do or was it as simple as moving the database and changing the odbc settings on the bes server? Was there any down time involved? Thanks. Steve Gargano Network Specialist One Centennial Square Haddonfield, NJ 08033 Direct Dial: 856-354-3039 Help Desk: 856-354-3062 Fax: 856-795-0574 sgarg...@archerlaw.com<mailto:sgarg...@archerlaw.com> www.archerlaw.com<http://www.archerlaw.com> [cid:image001.gif@01CA7CD4.63047D30]<http://www.archerlaw.com> IRS Circular 230 Disclaimer: To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. federal tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) voiding penalties under the Internal Revenue Code, or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein. INFORMATION CONTAINED IN THIS E-MAIL TRANSMISSION IS PRIVILEGED AND CONFIDENTIAL. IF YOU ARE NOT THE INTENDED RECIPIENT OF THIS EMAIL, DO NOT READ, DISTRIBUTE OR REPRODUCE THIS TRANSMISSION (INCLUDING ANY ATTACHMENTS). IF YOU HAVE RECEIVED THIS E-MAIL IN ERROR, PLEASE IMMEDIATELY NOTIFY THE SENDER BY TELEPHONE OR EMAIL REPLY.
<<inline: image001.gif>>
_______________________________________________ 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 ---------------------------------
