BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-25-2005, 12:56 PM   #1 (permalink)
New Member
 
Join Date: Oct 2005
Model: 7250
Posts: 5
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Move BES 4.0 to new server with same SQL server?

Please Login to Remove!

I have been searching through these forums and the Blackberry documentation but have not found a clear answer to this question.

Can I move my BES 4.0 installation to a new server (with a different server name) but use the existing database on the existing SQL server?

I understand the options for setting up the new server, and I know not to have both active at the same time. I just need to know whether or not I can install the BES software on the new server and just point it to the existing SQL server/database name, or will the difference in server name of the BES server cause it to fail?

The logical BES server name, as well as the SRP and auth key will all be the same.

Any insight?


Thanks!

P.S., I'm also hoping for the transition to be pretty seamless to the users. Am I on the right track?
Offline  
Old 10-26-2005, 04:26 AM   #2 (permalink)
Thumbs Must Hurt
 
Dustbin30's Avatar
 
Join Date: Sep 2005
Location: London
Model: 7230
Posts: 108
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yeah you can just point it at the old database. Make sure you have a back up of the database before.
Offline  
Old 10-27-2005, 07:40 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2005
Location: Toronto
Model: 8300
Carrier: Rogers
Posts: 100
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Don't forget to change the name in the ServerConfig table in SQL to match your new server!!!!!
Offline  
Old 11-15-2005, 08:19 AM   #4 (permalink)
CrackBerry Addict
 
rpfeffer's Avatar
 
Join Date: Mar 2005
Location: MD
Model: 9650
OS: 5.0.0.699
Carrier: Sprint BES
Posts: 530
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

vice versa...is there anything special that needs to be done when moving just the database to a new server? I am just now looking at this process and I would assume it would go something like this.

1- backup database
2- stop all blackberry services
3- copy database to new server
4- reconfigure BES to look at the new location for the database
5- restart all blackberry services

Am I correct in this assumption or does this just seem to easy?
Offline  
Old 11-15-2005, 08:37 AM   #5 (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

rpfeffer, the database is already in place.

1 - on the old BES, make note of the SRP Identifier, SRP Authentication Key, CAL Licenses, and BES instance name (what shows up in BlackBerry Manager for the name of the virtual BES server instance; for example, TESTBES1). i would suggest exporting the user list as well, but its not mandatory (nor is any of the above if you already have them elsewhere in hardcopy or softcopy format).

2 - on the old BES, set all BlackBerry services to manual and shut them down; if the server is being retired, go ahead and shut down the server after the above is completed.

* 3 - install BES on the new server; be sure to use the same BES service account, SRP Identifier, SRP Authentication Key, and BES instance name (what shows up in BlackBerry Manager). during the installation, point it to the same database that you were using in the past - this process *should* update the MachineName values in the ServerConfig tables mentioned by TheBerryGuru. do not select the option to start up the BlackBerry services at the end of the installation (uncheck).

* 4 - install either the like service pack you were using previously, or install the latest service pack (SP3). once again, do not select the option to start the services until you are on your last service pack. this whole process should *not* require a reboot of the server, but i'd recommend it after the last service pack is installed (i've had issues in the past where the database still read that it was 4.0.0.0 as the version, despite installing SP2).

* Note: If you are a TSupport customer, you can request a full version installation of BES 4.0 SP3 from RIM rather than having to install 4.0 then upgrade to SP3.
__________________
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 11-15-2005, 08:47 AM   #6 (permalink)
CrackBerry Addict
 
rpfeffer's Avatar
 
Join Date: Mar 2005
Location: MD
Model: 9650
OS: 5.0.0.699
Carrier: Sprint BES
Posts: 530
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by jibi
rpfeffer, the database is already in place.

1 - on the old BES, make note of the SRP Identifier, SRP Authentication Key, CAL Licenses, and BES instance name (what shows up in BlackBerry Manager for the name of the virtual BES server instance; for example, TESTBES1). i would suggest exporting the user list as well, but its not mandatory (nor is any of the above if you already have them elsewhere in hardcopy or softcopy format).

2 - on the old BES, set all BlackBerry services to manual and shut them down; if the server is being retired, go ahead and shut down the server after the above is completed.

* 3 - install BES on the new server; be sure to use the same BES service account, SRP Identifier, SRP Authentication Key, and BES instance name (what shows up in BlackBerry Manager). during the installation, point it to the same database that you were using in the past - this process *should* update the MachineName values in the ServerConfig tables mentioned by TheBerryGuru. do not select the option to start up the BlackBerry services at the end of the installation (uncheck).

* 4 - install either the like service pack you were using previously, or install the latest service pack (SP3). once again, do not select the option to start the services until you are on your last service pack. this whole process should *not* require a reboot of the server, but i'd recommend it after the last service pack is installed (i've had issues in the past where the database still read that it was 4.0.0.0 as the version, despite installing SP2).

* Note: If you are a TSupport customer, you can request a full version installation of BES 4.0 SP3 from RIM rather than having to install 4.0 then upgrade to SP3.
jibi, we are just moving the database itself. Not the server. I just read your how-to on this at the following link.

HOWTO: Migrate MSDE2K or SQL2K database to new server

The database is currently located on a remote server, we are simply moving it to a different remote server.
Offline  
Old 11-15-2005, 09:04 AM   #7 (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

oh. haha. i thought you were talking about his situation. woops.

i think the easiest approach would be to configure the BES to point to the new database server and set it up for something like BESTest rather than BESMgmt for the database. this will allow it to create the system table entries. once that's done, copy the old database over there, mount it, and then point the BES to it (Server Config - change to BESMgmt from BESTest). once done, delete the BESTest database from the SQL server along with the SQL jobs it created for it.
__________________
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 11-15-2005, 09:11 AM   #8 (permalink)
CrackBerry Addict
 
rpfeffer's Avatar
 
Join Date: Mar 2005
Location: MD
Model: 9650
OS: 5.0.0.699
Carrier: Sprint BES
Posts: 530
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by jibi
oh. haha. i thought you were talking about his situation. woops.

i think the easiest approach would be to configure the BES to point to the new database server and set it up for something like BESTest rather than BESMgmt for the database. this will allow it to create the system table entries. once that's done, copy the old database over there, mount it, and then point the BES to it (Server Config - change to BESMgmt from BESTest). once done, delete the BESTest database from the SQL server along with the SQL jobs it created for it.
Is BESTest an existing DB, or would I need to create it?
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.