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


NEW OEM Battery A1466 A1369 A1496 A1405 A1377 A1466 for MacBook Air 13 inch picture

NEW OEM Battery A1466 A1369 A1496 A1405 A1377 A1466 for MacBook Air 13 inch

$35.90



For iPhone 5 5s 6 Plus 6S 6 6S Plus 7 8 Plus LCD Display+ Touch Replacement OEM picture

For iPhone 5 5s 6 Plus 6S 6 6S Plus 7 8 Plus LCD Display+ Touch Replacement OEM

$29.88



NEW OEM A1618 Battery for Apple MacBook Pro 15” Retina 99.5Wh A1398 Mid 2015 picture

NEW OEM A1618 Battery for Apple MacBook Pro 15” Retina 99.5Wh A1398 Mid 2015

$49.90



OEM Battery for MacBook Pro 17

OEM Battery for MacBook Pro 17" A1309 A1297 Early 2009 Mid 2009 2010 MC226

$42.80



A1417 OEM Battery for Apple Macbook Pro 15 Retina A1398 Mid 2012 Early 2013 US picture

A1417 OEM Battery for Apple Macbook Pro 15 Retina A1398 Mid 2012 Early 2013 US

$45.90



A1618 NEW OEM Battery for MacBook Pro 15

A1618 NEW OEM Battery for MacBook Pro 15" Retina A1398 Mid 2015 020-00079

$49.90







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