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


OMTech 40W CO2 Laser Engraver K40+ Motherboard for Lightburn & Rotary Axis Comp. picture

OMTech 40W CO2 Laser Engraver K40+ Motherboard for Lightburn & Rotary Axis Comp.

$151.99



AAEON UP Single Board Computers UP Squared Pro, UPN-APLC2F-A10-0432 picture

AAEON UP Single Board Computers UP Squared Pro, UPN-APLC2F-A10-0432

$210.00



AXIOMTEK CEM830 REV.B1-RC - Socket M Intel Core 2 Duo IND. EMBEDDED MOTHERBOARD picture

AXIOMTEK CEM830 REV.B1-RC - Socket M Intel Core 2 Duo IND. EMBEDDED MOTHERBOARD

$449.99



(NOS) SEMCO - PC CONTROL BOARD - T144 - ELECTRONIC INTEGRATOR - NEW in BOX picture

(NOS) SEMCO - PC CONTROL BOARD - T144 - ELECTRONIC INTEGRATOR - NEW in BOX

$116.55



Doorking dks 1834-080 Telephone Entry System Motherboard (1834-010)  picture

Doorking dks 1834-080 Telephone Entry System Motherboard (1834-010)

$699.00



Hubbell Replacemet Motherboard for CP04 Series 4-Relay Load:Logic Panel CPMBRD04 picture

Hubbell Replacemet Motherboard for CP04 Series 4-Relay Load:Logic Panel CPMBRD04

$206.99







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