?
Solved

migrating bes database and server

Posted on 2009-05-12
17
Medium Priority
?
639 Views
Last Modified: 2012-05-06
We have a bes version 4.16 running MSDE and we are looking to migrate to a virtual bes ver 5.0 with sql. What is the simplest way to do this without impacting end user's blackberrys? Is that even possible. What are out options?
0
Comment
Question by:nohman27
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
  • 2
17 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24369627
---hmm after new sql server msde   is created just try to restore old db  over new one
or export records from old db...


0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24369630
typo :created: read = >installed
0
 

Author Comment

by:nohman27
ID: 24374675
well, im under the impression that migrating an MSDE database to a full SQL databse is not that simple. The way we have to do it now would require touching all 60+ blackberries and reactivating each one. Is there a way for the servers to talk to one another so that the move tool would see the second server. Essentially I want to know what our options are.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 26

Accepted Solution

by:
Gary Cutri earned 2000 total points
ID: 24376316
Hi, follow my guide below and just replace the "Installing the New BES" section with your BES 5.0 installation.

http://www.blackberryforums.com.au/forums/microsoft-exchange/4456-migrate-bes-4-1-new-server.html
0
 

Author Comment

by:nohman27
ID: 24376420
We are moving for a 4.1 to a 5.0 though. They are not the same version. Also, Im pretty sure MSDE and SQL cant be used interchangeably. The old bes is using MSDE and the new one should be running SQL.
0
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24376677
As mentioned follow the steps in my guide to move the database and then install BES 5.  When you install BES 5 it will upgrade the database that you have migrated.  As an FYI the database from MSDE can be restored directly to a full SQL 2000 or 2005 (as long as you create the blank database first).  Assuming you have SQL 2005 all the steps in my guide above are the same as using SQL 2005 Express with the Express Manager.  Also here are a few tips for you from my forum:

http://www.blackberryforums.com.au/forums/tags/bas.html
0
 

Author Comment

by:nohman27
ID: 24376841
Has this ever been tested? the migration from 4.1 to 5.0 that is? and MSDE to SQL? You have to understand my caution when proceeding because this is 60 some-odd blackberries that would go down and if we had to touch each one, we'd out of work pretty quicky.
0
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24377148
I have done it 24 times in the past week (I do all the installs for a major carrier and have clocked up over 4900 BES installs in the past 3 years).  If you are not confident hire a Blackberry expert to do it for you.  Personally I wouldnt recommend moving to BES 5.0 until at least the first maintenance release is made available.  To start with just move the database over to SQL and point to current BES to it and test.  After a few days stop and disable the current BES services and edit the SQL tables I mentioned, then install BES on the new server and point it to the SQL database.  Once everything has been running for a while take a VM snapshot and upgrade it to BES 5.0.  If you are worried about the move send me a message using the link below and I can do a webex session and I can show you how its done.

http://www.blackberryforums.com.au/forums/sendmessage.php
0
 
LVL 26

Assisted Solution

by:Gary Cutri
Gary Cutri earned 2000 total points
ID: 24377370
As an FYI you can move your MSDE database to SQL and point your current BES to it and have all users running again in under 15 minutes (technically it will do a mailbox rescan which can cause a few message delays but user generally wont even notice).
0
 

Author Comment

by:nohman27
ID: 24377375
I would agree with that strategy. how simple or complex is the upgrade from 4.1 to 5.0?
0
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24377406
To upgrade to BES 5 is as simple as installing over the top (just make sure you select the AD integration option).  The considerations are BES 5 uses 2x the memory as BES 4.1 and the installation takes up 2.5GB of HD space.  If you run Exchange System Manager on the BES you need to ensure the BAS port is changed from 443 to a different port (e.g. 663).
0
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24377442
Also I have found that the BlackBerry Monitoring service (one of the install options) causes a major resource drain so I am excluding it from installations.  Please keep in mind that BES 5 will only give you a new interface and failover option at this stage. The device firmware version 5.0 is required to access all the new handheld options (this is still a number of months away).
0
 

Author Comment

by:nohman27
ID: 24377633
would you recommend we instead move to a bes 4.6 until 5.o is refined? How long would a migration like this take?
0
 
LVL 26

Expert Comment

by:Gary Cutri
ID: 24377695
There is no BES 4.6 but I assume you are referring to BES 4.1.6?  To move your database to SQL and install BES 4.1.6 on a new server should take 30 minutes (max 45 minutes).  Just make sure your new BES has the local Permissions set for the BlackBerry Service Account and Exchange System Manager installed (including Exchange SP2 and any applicable DST updates).  If your current BES is version 4.1.6.x it is recommended that you have a copy of the full BES 4.1.6 installer (i.e. besx_4.1.6.exe) to run on the new server.
0
 

Author Comment

by:nohman27
ID: 24379394
One more question. What is a good way to migrate from MSDE to SQL. ANything specific that may cause issues?
0
 
LVL 26

Assisted Solution

by:Gary Cutri
Gary Cutri earned 2000 total points
ID: 24381658
The short version:

1. Create a new blank BESMgmt database on the SQL server  by coping the database directory from the BES installer files to the SQL server and running createdb.exe. (as you have SP6 ensure you copy the database folder from the SP6 installer)
2. Add the BlackBerry Service Account to the security folder on SQL and give it sysadmin and dbcreator permissions.
3. Stop the services on the BES
4. Create a backup of the database
5. Restore the backup over the new database in SQL.
6. On the BES open BlackBerry Server Configuration and point it to the database on the SQL server
7. Start the services.
0
 

Author Comment

by:nohman27
ID: 24384561
Yeah we did this last night and it went well, however there are a few things that didn't really match up in the instructions. First of all, creating the databse on SQL Server is actually unnecessary because in (at least) SQL 2005, the backup would not restore because the databases didnt match. I had to delete the database that i created and simply use the command line prompt for MSDE to restore the database correctly. Once I did that it seemed to be working fine. Also just starting the services does NOT switch your BES to the new BESMgmt SQL server. You have to detach the msde database which will call BBDM to error out, When you open it the second time it will rescan the database and add the new one. That may not be the safest way to do it though since after I did it, it lost the MAPI info.

Either way i simply reinstalled thr 4.1.6 ugrade and gave it about 20 minutes to rescan all the mailboxes and it looks like we were good to go.

Thanks for you helpful guides and support. It seems as thought the guide is written solely for SQL 2000 though. I had to download the sql management studio express and kind of slowly figure out what the equivalents were. That was also kind of frustratiing. Nevertheless, it was very helpful. Just wanted to let you know some differences I encountered.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question