BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 12-21-2008, 10:35 PM   #1
jwor
New Member
 
Join Date: Dec 2008
Model: 3810
PIN: N/A
Carrier: Vodaphone
Posts: 1
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?
Offline  
Old 12-23-2008, 08:56 AM   #2
BBFlunkie
Thumbs Must Hurt
 
Join Date: May 2007
Location: Columbus, OH
Model: 9000
PIN: N/A
Carrier: AT&T
Posts: 62
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.

Reboot.

Turned off MSDE.

Reboot again.
All was well.
Offline  
Old 12-23-2008, 09:54 AM   #3
mahoward
CrackBerry Addict
 
mahoward's Avatar
 
Join Date: May 2005
Model: 8900
Carrier: T-Mobile
Posts: 560
Default

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
Offline  
Old 12-23-2008, 12:09 PM   #4
freakinvibe
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: Class
PIN: N/A
Carrier: Swisscom
Posts: 1,616
Default

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
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


Audio Polarity Checker Phase Detector Self-Test Auto-Off PD-9A Speaker Tester picture

Audio Polarity Checker Phase Detector Self-Test Auto-Off PD-9A Speaker Tester

$43.00



IndusTec DC 20A Motor Polarity Reversing - Toggle Switch Maintained DPDT 3 Pos picture

IndusTec DC 20A Motor Polarity Reversing - Toggle Switch Maintained DPDT 3 Pos

$14.99



Honeywell Quartz Polarity Sensitive Hour Meter 85098 picture

Honeywell Quartz Polarity Sensitive Hour Meter 85098

$79.99



IndusTec 20 AMP 12v DC Momentary Reverse Polarity Rocker Switch DPDT SEE VIDEO picture

IndusTec 20 AMP 12v DC Momentary Reverse Polarity Rocker Switch DPDT SEE VIDEO

$9.99



Allen Bradley 937ZH-DPBN-2 Intrinsic Safety Zener Barrier, Positive Polarity DC picture

Allen Bradley 937ZH-DPBN-2 Intrinsic Safety Zener Barrier, Positive Polarity DC

$139.99



Dairyland PCR-5KA Polarization Cell Replacement With Box. picture

Dairyland PCR-5KA Polarization Cell Replacement With Box.

$299.99







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