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


Beautiful Leather Journal - Vintage Brown picture

Beautiful Leather Journal - Vintage Brown

$10.20



10 Rolls - ASSORTED COLORS - Vintage DYMO Labeling Tape 3/8

10 Rolls - ASSORTED COLORS - Vintage DYMO Labeling Tape 3/8" x 144”

$19.95



Vintage Journal 220 Antique Paper 7 X 5 inches Leather Bound Handmade Diary picture

Vintage Journal 220 Antique Paper 7 X 5 inches Leather Bound Handmade Diary

$19.79



First Trust Bank and Savings Vintage Letterpress Block picture

First Trust Bank and Savings Vintage Letterpress Block

$22.59



Flat File Vintage Large Brown Wooden Drafting Cabinet picture

Flat File Vintage Large Brown Wooden Drafting Cabinet

$250.00



Massive Lot Vintage Carl Zeiss Optical Eyepiece  Microscope Lens Made in Germany picture

Massive Lot Vintage Carl Zeiss Optical Eyepiece Microscope Lens Made in Germany

$199.99







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