BlackBerry Forums Support Community

Closed Thread
LinkBack Thread Tools
Old 12-21-2008, 10:35 PM   #1 (permalink)
New Member
Join Date: Dec 2008
Model: 3810
Carrier: Vodaphone
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES 4.1.6 SQL Database migration to SQL 2005 Cluster Environment

Please Login to Remove!

Folks - BES 4.1.6 SQL Db to SQL 2005 cluster.

I am told there are particular gotchas when migrating a BES SQL Db for the BES server to a dedicated SQL environment.
I have been advised in no uncertain terms that housing the BES SQL Db on the BES server when there is SQL 2005 cluster available is very bad practice.
Has any one got a document detailing the process of migrating a BES SQL Db from the BES server to the SQL environment?
Old 12-23-2008, 08:56 AM   #2 (permalink)
Thumbs Must Hurt
Join Date: May 2007
Location: Columbus, OH
Model: 9000
Carrier: AT&T
Posts: 62
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Your SQL Admin should be able to help with this

SQL Admin just copied the MSDE database to the SQL server.
SQL Admin did all the Attach functions.
SQL Admin adjusted the database rights.

Changed the database using Server Configuration.

Manually changed all registry keys on BES.


Turned off MSDE.

Reboot again.
All was well.
Old 12-23-2008, 09:54 AM   #3 (permalink)
CrackBerry Addict
mahoward's Avatar
Join Date: May 2005
Model: 8900
Carrier: T-Mobile
Posts: 560
Post Thanks: 0
Thanked 1 Time in 1 Post

Don't forget to run the dbcreate.exe to populate the sysmessages table and scheduled jobs first.
BESX 4.1.7 on Exchange 2003: 65 Devices
BESX 5.0.3 on Exchange 2003: 2007 Devices
Old 12-23-2008, 12:09 PM   #4 (permalink)
BlackBerry Extraordinaire
Join Date: Aug 2008
Location: Basel
Model: Class
Carrier: Swisscom
Posts: 1,616
Post Thanks: 6
Thanked 122 Times in 119 Posts

Check the following knowledge base article from RIM, which explains the procedure

"How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instance"
Link to RIM KB03112

Copyright 2004-2016
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.