BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 04-20-2005, 07:01 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Apr 2005
Location: St. Louis
Model: 7750
Posts: 66
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Moving BES DB from MSDE to SQL

Please Login to Remove!

I am currently running an eval BES 4.0 with approx 30 pilot users on it (all handhelds 4.0 as well). The eval install was all defaults, so it has MSDE database on the same server as the BES. For disaster recovery and failover ease, I want to move the DB to SQL and put it on another box - a clustered SQL server. When I do this, can I just point the BES to the new SQL location, or will I have to do a reinstall overtop the current BES?

I am getting activation for the BES anytime now, and I was thinking of doing all of this at the same time: move DB off server to SQL server, reinstall BES (if needed) and activate it, and then apply SP1.

Anyone have thoughts/tips on this situation?
Thanks in advance, everyone here is always so helpful.
Offline  
Old 04-20-2005, 08:53 PM   #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

Simple really. Shut down the BES services and stop msde. Find the besmgmt ldf and mdf files on the msde machine and copy them to the data directory of the sql machine. Then open up SQL manager and attach those databases (right click attach database if i recall). Then fire up BES mgmt console (it may say cant connect to db) and point it towards the new database. Start services and should be cool.
__________________
BES Admin, sometime God.
Offline  
Old 04-20-2005, 10:58 PM   #3 (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

just remember there are 2 places to change settings for the BES. one is in BlackBerry Manager and the other is in BlackBerry Server Configuration (i think thats the right name... both are in the start menu). the latter is the main place to change it (or you can do as greywolfe stated), but the first one will have to be changed if you want to get the correct information in BB Manager or Handheld Configuration Tool.
__________________
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  
Old 04-20-2005, 11:09 PM   #4 (permalink)
BBF Veteran User
 
Join Date: Aug 2004
Location: Hotwiring another Cessna
Model: OU812
Carrier: Nintendo
Posts: 3,492
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just curious....

Has anyone tried merging databases from MSDE to SQL?

For example. We're switching to SQL in the near future, but currently have all of our users on MSDE. We'll test with SQL with test account (presumably our own - administrator), then work on transferring the users' database to SQL, but we don't want to overright our database files.

I was just going to send out the wireless activation email and instructions to users, but if we can seamlessly transfer individual accounts from MDSE to SQL that would be better.
Offline  
Old 04-21-2005, 01:46 AM   #5 (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

import the database to the sql server then merge them there. just make sure both databases are from *exactly* the same BES version!
__________________
BES Admin, sometime God.
Offline  
Old 04-21-2005, 07:38 AM   #6 (permalink)
BBF Veteran User
 
Join Date: Aug 2004
Location: Hotwiring another Cessna
Model: OU812
Carrier: Nintendo
Posts: 3,492
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks
Offline  
Old 04-21-2005, 08:50 AM   #7 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Mar 2005
Location: Washington DC
Model: all
Carrier: All carrier's
Posts: 315
Post Thanks: 0
Thanked 0 Times in 0 Posts
Talking

is it necessary to migrate? Just wondering, my place doesn't have a dedicated SQL box, so I was just wondering...
Offline  
Old 04-21-2005, 09:28 AM   #8 (permalink)
BBF Veteran User
 
Join Date: Aug 2004
Location: Hotwiring another Cessna
Model: OU812
Carrier: Nintendo
Posts: 3,492
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

At least with migration, after SP1 is released, we probably won't have to reactivate handhelds.
Offline  
Old 04-22-2005, 12:47 PM   #9 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Feb 2005
Model: 7280
Carrier: cingular, no wait, AT&T
Posts: 300
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by bbgirl
is it necessary to migrate? Just wondering, my place doesn't have a dedicated SQL box, so I was just wondering...
Just run the BES on the same server as the SQL server. Unless you're running like 10k users or you're running BES on a Pentium 2, you'll be fine. SQL Server is so much better...
A good BES machine will have like a P4 w/HT and 2gigs of RAM, so it ought to be able to handle SQL server.
Offline  
Old 04-22-2005, 01:03 PM   #10 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Mar 2005
Location: Washington DC
Model: all
Carrier: All carrier's
Posts: 315
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Or the other way around...we aren't using SQL for anything yet. What is the differenc? Between msde and sql....
Offline  
Old 04-22-2005, 01:06 PM   #11 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Mar 2005
Location: Washington DC
Model: all
Carrier: All carrier's
Posts: 315
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry if it sounds dumb..
Offline  
Old 04-22-2005, 01:09 PM   #12 (permalink)
BBF Veteran User
 
Join Date: Aug 2004
Location: Hotwiring another Cessna
Model: OU812
Carrier: Nintendo
Posts: 3,492
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by bbgirl
Or the other way around...we aren't using SQL for anything yet. What is the differenc? Between msde and sql....
MSDE is limited to 8 concurrent connections at a time.
Offline  
Old 04-22-2005, 01:50 PM   #13 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Feb 2005
Model: 7280
Carrier: cingular, no wait, AT&T
Posts: 300
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by bfrye
MSDE is limited to 8 concurrent connections at a time.
MSDE is a toy DB, just like Access is.
Offline  
Old 04-22-2005, 01:52 PM   #14 (permalink)
BBF Veteran User
 
Join Date: Aug 2004
Location: Hotwiring another Cessna
Model: OU812
Carrier: Nintendo
Posts: 3,492
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by DoomBringer
MSDE is a toy DB, just like Access is.
It would work decent for those places that have BES with a small userbase, like <50 or so. But after that it starts to crap out.
Offline  
Old 06-12-2005, 09:54 PM   #15 (permalink)
New Member
 
Join Date: May 2005
Model: 7280
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Migration

Hi all,

I'm currently ruuning a project pretty much the same deal as mentioned.

This is want I did...

Logged into the new server as the service account created in the ADS for the Blackberry service.
Installed MSDE on the new server and SQL 2000 Enterprise management. And installed Exchange 2003 management tools to get the correct CDO.DLL.

Disabled MSDE on the old server copied BESMgmt.ldf and BESMgmt.mdf to the new server. Opened enterprise Manager and attached the copied database, Opened the "ServerConfig" table and changed the "ServiceName" and "MachineName" to reflex the new server name.

I then disable all BlackBerry services on the old server and diable MCSE on the old server and rebooted.

after the old server was rebooted I double checked the old server to make sure that the services etc will infact disabled.

Back to the new server I installed BlackBerry enterprise server (Typical installation). I pointed to the BESMgmt on the new server (same server as the MSDE server), tested the connectivity to the database which passed, then setup the email instance, check the SRP information was brought accross and test the SRP which passed, tested host connectivity back to BackBerry this also passed.

Opened up BlackBerry manager when connected error free to the database and showed the correct user base etc and that all services were running correctly.

I grabbed my handheld and create a new email, the email was delivered without error. I then attempted to send an email to the handheld, this is where this went wrong, although every thing looked 100% ie all the services etc try as I might I would not get email to a hand held.

At this time I ran out of time to I revirsed the process back to the old server.

Any have any idea's why I might be getting single direction commucation?

Thanks in advance

Shaun
Offline  
Old 08-02-2005, 08:29 AM   #16 (permalink)
New Member
 
Telecom Lackey's Avatar
 
Join Date: Aug 2005
Model: 7520
Posts: 5
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default synchronizing

I seem to have a problem synchronizing appointments in Calendar. Appointment created in OL will appear on BlackBerry but not the other way around.
Offline  
Old 08-02-2005, 08:49 AM   #17 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8830
Carrier: Verizon
Posts: 35
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Spawn....when you send a message to the handheld, does the user stats for this user indicate a message pending or does it "appear" to route?
Offline  
Old 08-02-2005, 09:50 AM   #18 (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

Quote:
Originally Posted by Telecom Lackey
I seem to have a problem synchronizing appointments in Calendar. Appointment created in OL will appear on BlackBerry but not the other way around.
I don't really see how that issue has ANYTHING to do with this topic, but you need to look at the CDO.dll to fix your issues, most likely. You can try doing searches on 'calendar' or 'cdo.dll' to figure out possible solutions for your synchronization problems.
__________________
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  




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