BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-30-2007, 04:31 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 7100
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Knife-Edge Migration

Please Login to Remove!

I've reviewed the knife-edge migration [HERE], but I'm confused about the order of the steps.

In step 3 it mentions to backup and restore the existing servers database, however how can you do that if you haven't already installed the BES software on the new server which is stated as step 6, where, interestingly enough, there is no specific mention of restoring the database.
Offline  
Old 10-30-2007, 05:53 PM   #2 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

If you are using SQL you don't need to do Step 3 as the direction said.

If you using MSDE, you can install MSDE from the BES installation CD. Run sqlrun01.msi from the tools directory. Then perform Step 3.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 10-30-2007, 08:14 PM   #3 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you going from a Local MSDE to a new Local MSDE? Are the server hostnames (in addition to the BES Server Name) staying the same?
Offline  
Old 10-31-2007, 01:19 AM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 7100
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

It's local MSDE to local MSDE and I have the choice of whether the hostnames will be the same or not.
Offline  
Old 10-31-2007, 06:09 AM   #5 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Intex View Post
It's local MSDE to local MSDE and I have the choice of whether the hostnames will be the same or not.
Cool -

So you'll want to:

1) Schedule a nice downtime window
2) Document your SRP / CAL / BES Server name
3) Stop BES Services on current server (and set to disabled)
4) Backup database
5) Copy database to new server (along with any custom software / applications you've had the BES install to your HHs)
6) Turn off current BES (Your going to change the hostname to match)
7) Reset AD Computer account object for your BES
8) Add new server to AD domain with same name as original server
9) Perform prerequisite installation requirements (including install MDSE ... you can find directions on this site and through google on procedures to manually install MSDE)
10) Restore database on new server
11) Begin installation of BES Software (if it is a newer version you'll simply upgrade the database in place as you install the software... just make sure you have the full installer from RIM) ... don't use an older version of the software.
12) Once the install is complete, make sure you schedule backups of your MSDE database (search the forum for msde backup and you'll find a script I wrote to automate this for you).

questions?
Offline  
Old 10-31-2007, 06:54 AM   #6 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 7100
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the steps.

I'm still a bit unsure about the database piece. Are you saying you should install MSDE and restore the database from the current BES server, prior to installing the BES software?

Couldn't we simply rename the new target system to match the existing BES server, install BES that matches the existing system, which will install MSDE, name everything the same as the existing system and then start everything up (obviously the existing server has been turned off already)?
Offline  
Old 10-31-2007, 07:05 AM   #7 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
I'm still a bit unsure about the database piece. Are you saying you should install MSDE and restore the database from the current BES server, prior to installing the BES software?
Yes.

Quote:
Couldn't we simply rename the new target system to match the existing BES server, install BES that matches the existing system, which will install MSDE, name everything the same as the existing system and then start everything up (obviously the existing server has been turned off already)
Indeed you could ... before you start the new server though you'd want to restore the database. The added benefit of restoring prior to the install is you don't need to enter in the SRP / CAL info as its already in the database. The added benefit of restoring after you've installed the software is that you don't need to install MSDE manually ... just make sure to restore before you start the BES services ... either way will work however.
Offline  
Old 10-31-2007, 07:13 AM   #8 (permalink)
Wireless Sith Lord
 
DarthBBerry's Avatar
 
Join Date: Jan 2007
Location: Online
Model: iOS 6
Carrier: Verizon x2
Posts: 1,458
Post Thanks: 2
Thanked 27 Times in 22 Posts
Default

When I did my knife edge last week, I backed up the database, installed BES on the new box, entered in SRP and 1 CAL, THEN dropped the DB into place and restarted all services. Worked just fine.

If I had restored the DB before I installed BES, I could've just pointed the installation to the DB and continued onward. Either way, it works.
__________________
DarthBBerry
6-Time BlackBerry World Champion (2007-2012)
BlackBerry® Certified Support Specialist v5.0
BlackBerry® Certified System Administrator v5.0
Offline  
Old 10-31-2007, 07:27 AM   #9 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 7100
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the help / advise guys.
Offline  
Old 10-31-2007, 06:09 PM   #10 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 7100
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm currently doing this migration now and when it comes to type in the name of the SQL Server Name and Database name and I select MSDE as the database, it says it doesn't exist and would I like to create it. Obviously I do want to create it, but as soon as I do I get the message:

DB upgrade failed. Error executing an SQL statement

My only option is to select OK and it returns to same configuration screen. I already tried removing MSDE and the BES software via control panel, restarted and tried again and that didn't work.

Any ideas? Our BES server is currently down, so any help appreciated.
Offline  
Old 10-31-2007, 06:15 PM   #11 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 7100
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I tried selecting a different database name and that worked, so I guess that it thought there was a duplicate there for some reason.

As I've created a new database name, can I still run the database restore and that will restore the live database and is there anything else I'd need to change?
Offline  
Old 10-31-2007, 06:26 PM   #12 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can still run the database restore ... you'll just need to restore it as the new database name as the database thinks it is still BESMgmt
Offline  
Old 10-31-2007, 06:33 PM   #13 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 7100
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, I've solved this issue. The same database was in the SQL data directory and after removing that, I re-ran the BES installation and the database created successfully.

Database has now restored, I've restarted the server and the BES server is shown as green in BES Manager.

How long does it take for handhelds to start working again? At the moment the server has been up for a few minutes and they can't do lookups or receive emails.
Offline  
Old 10-31-2007, 06:43 PM   #14 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

are all the HHs showing in the BES Manager? Should be but a few minutes ... how many users again?
Offline  
Old 10-31-2007, 06:44 PM   #15 (permalink)
Knows Where the Search Button Is
 
Join Date: Sep 2006
Model: 7100
Carrier: Vodafone
Posts: 18
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

All working now .
Offline  
Old 10-31-2007, 06:56 PM   #16 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Glad to hear! nice job.
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.