BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-07-2005, 12:24 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Model: 8300
Carrier: AT&T
Posts: 180
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Move from MSDE to SQL server 2k...

Please Login to Remove!

What would I see the most improvement in blackberry enterprise server if I migrate to SQL Server 2k from MSDE? How hard is it to migrate from MSDE to SQL Server?

Thanks!
Offline  
Old 10-07-2005, 12:29 AM   #2 (permalink)
Talking BlackBerry Encyclopedia
 
greywolfe's Avatar
 
Join Date: Mar 2005
Location: NSW, Australia
Model: 8100
Carrier: optus
Posts: 303
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Its as easy as shutting down MSDE, copying the *.mdf and *.ldf files to the SQL data directory, then attaching the databases in SQL Manager. Very easy.
__________________
BES Admin, sometime God.
Offline  
Old 10-07-2005, 07:10 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2005
Location: Denmark
Model: 7230
Carrier: TDC
Posts: 102
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by greywolfe
Its as easy as shutting down MSDE, copying the *.mdf and *.ldf files to the SQL data directory, then attaching the databases in SQL Manager. Very easy.

and update the master database
Offline  
Old 10-07-2005, 08:03 AM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
boma0021's Avatar
 
Join Date: Jan 2005
Location: LE
Model: Pearl
Carrier: T-Mobile
Posts: 202
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

jibi has written a pretty cool howto

HOWTO: Migrate MSDE2K or SQL2K database to new server
Offline  
Old 10-07-2005, 09:21 AM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2004
Model: 8300
Carrier: AT&T
Posts: 180
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Last question. What is the best procedure to remove MSDE and install SQL Server if it is on the same box for Exchange and BES? Thanks again for everybody's reponses.
Offline  
Old 10-07-2005, 09:25 AM   #6 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

stop the SQL services associated with MSDE. copy off the MDF/LDF files to a safe location. uninstall MSDE. install SQL. install service packs. create a new BESMgmt (or BESTest) instance from within the BlackBerry software (move its database configuration to a 'new server'), thus creating the system database entries. stop SQL services. copy the newly created SQL MDF/LDF files elsewhere. copy the old ones back over. start SQL services.

...or follow the instructions in the link above, except treat it like one server rather than a remote one. same concept.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





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