BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-13-2008, 08:46 AM   #1 (permalink)
New Member
 
Join Date: May 2008
Model: 8700G
PIN: N/A
Carrier: T-Mobile
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default No Downtime Migration of BES Server to new Hardware - Issue

Please Login to Remove!

I have to migrate our current BES server (4.1.5) from it's old hardware on Windows 2000, to a newer bit of kit on Windows 2003.

Unfortunately for lots of boring business reasons, wholesale downtime is not an option. I have built bit's of kit to test the process but I have hit on a teeny snag. This is where I have got to so far.

I install BES on the new server absolutely fine, I then run the config util and point it at the SQL database of the old one, I then see both servers happily, and I can drag handsets across just fine, I have no issue moving the SQL database to the new server either.

However, I uninstall BES from the original and delete the server object from the console just fine, but the Original Servers MDS objects won't go from the console. Thats the _BBIM and the _CS ones.

Anyone have an idea how to clean up these bits ? I have heard tell that the only way to do this is to manually remove them from the SQL database.

Can anyone confirm this is the only way, and if so tell me which tables or entires in SQL I need to delete
Offline  
Old 05-13-2008, 09:01 AM   #2 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Oct 2007
Model: 8830
PIN: N/A
Carrier: Sprint, Alltel
Posts: 262
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Any reason why you aren't doing a knife-edge move? When you are done, you just shut off the old server.

BlackBerry Search Results
Offline  
Old 05-13-2008, 09:18 AM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2004
Location: Boston
Model: 9000
Carrier: AT&T
Posts: 40
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Why not purchase a migration kit from RIM which will give you a new SRP to install on the new server, get both running in parallel, pointing the new server to the database on the old server, migrate users one at a time from one server to the other (no new activation required) when that is done, copy the databases from the old server to the new. One major assumption is the BES and SQL/MSDE versions are the same on both servers.
Offline  
Old 05-13-2008, 09:27 AM   #4 (permalink)
New Member
 
Join Date: May 2008
Model: 8700G
PIN: N/A
Carrier: T-Mobile
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

My apologies for not being clearer ckent. This is exactly what I am doing

I have a spare SRP's, I have done the migration one at a time like you say and moved the SQL databases to the new box, but when I uninstall the original server some stuff remains in the console on the new machine.
Offline  
Old 05-13-2008, 09:39 AM   #5 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2004
Location: Boston
Model: 9000
Carrier: AT&T
Posts: 40
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Had a similar issue, had to bring the old machine back online, point it to the new SQL databases, then remove the old MDS items from the management console. This was after working with T-Support folks, according to them there is also a way to remove these items manually from the database(s) but we didn't need to take it to that level.
Offline  
Old 05-13-2008, 09:56 AM   #6 (permalink)
New Member
 
Join Date: May 2008
Model: 8700G
PIN: N/A
Carrier: T-Mobile
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

ahhh, the old server has been rebuilt for another test.

Are you saying the uninstall did not work correctly, or that there is a way to remove MDS before the decomission ?
Offline  
Old 05-13-2008, 10:02 AM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2004
Location: Boston
Model: 9000
Carrier: AT&T
Posts: 40
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

We were warned ahead of time about the un-install not likely to work properly. My advice at this point if the old server is non-recoverable would be to get on the phone with RIM and have them walk you through the SQL statements required to clean up the environment.
Offline  
Old 05-13-2008, 10:05 AM   #8 (permalink)
New Member
 
Join Date: May 2008
Model: 8700G
PIN: N/A
Carrier: T-Mobile
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I thought as much, thanks

Does anybody know what these SQL commands are ?
Offline  
Old 05-23-2008, 06:54 AM   #9 (permalink)
New Member
 
Join Date: May 2008
Model: 8700G
PIN: N/A
Carrier: T-Mobile
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Come one, SOMEONE must know how to do this !!!!
Offline  
Old 05-23-2008, 07:43 AM   #10 (permalink)
CrackBerry Addict
 
bertiebassett's Avatar
 
Join Date: Aug 2005
Location: London, UK
Model: 9700
Carrier: O2
Posts: 961
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Headbolt View Post
Come one, SOMEONE must know how to do this !!!!
yeah RIM do..

Whilst I'm happy to provide general advise to other users on this forum I think you'd find not that many people would be that keen to provide advice on SQL commands that write/delete data to your BES dbase, and I don't think it's that common a problem so the vast majority of readers might not have come across it..

Loooking at it another way - would you want to go to your "no downtime is acceptable" boss and tell him you hosed the BES as you executed a command you read about on an internet forum...

I'd seriously suggest you get on the phone to RIM and get them to email exactly the correct commands to you...that way you've CYA'd.
__________________
LOTS of answers here: Main Page - BlackBerryFAQ
Offline  
Old 05-23-2008, 07:49 AM   #11 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
Post Thanks: 6
Thanked 30 Times in 29 Posts
Default

BlackBerry Search Results
Offline  
Old 05-23-2008, 09:28 AM   #12 (permalink)
New Member
 
Join Date: May 2008
Model: 8700G
PIN: N/A
Carrier: T-Mobile
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, fixed it now

I used the SQL Managment Studio Express tool, Opened the Database and opened the tables listed below, deleted the lines for the offending server out of each table and hey presto.

MDSConfig
MDSAGConfig
IMConfig
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.