BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-10-2007, 12:38 PM   #1 (permalink)
New Member
 
Join Date: Jun 2007
Model: 8703e
PIN: N/A
Carrier: Sprint
Posts: 5
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Move X amount of users from one environment to another with diff SQL versions.

Please Login to Remove!

We would like to accomplish the following:
Move a % of users from their current BES environment to a another BES environment.
Current environment for the users that need to be moved.
Server1 - BES v4.1.3 Server2 - SQL2000 server.

New environment that the users will be moved to.
Server1 - BES v4.1.3 Server2 - SQL2005 Enterprise Server.

Our BES admin. moved a couple users to the new BES which is still pointing to the (current environment ) SQL server. These are the only users on the new BES at this time.

When all of the accounts are moved to the new BES server, can we just backup the current SQL database and restore it to the new environment database that is running SQL2005?

Any problems with backing up a BESMgmt from SQL2000 and restoring to a BESMgmt running SQL2005?

Thanks in advance
Offline  
Old 09-10-2007, 12:45 PM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Its actually pretty straight forward ... How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instance

going to 2000 / 2005 couldn't be easier ... as long as you follow EACH AND EVERY STEP ... don't go thinkin you can skip stuff like I did the first time I tried

... its not just a simple backup and restore though.
Offline  
Old 09-11-2007, 10:45 AM   #3 (permalink)
New Member
 
Join Date: Jun 2007
Model: 8703e
PIN: N/A
Carrier: Sprint
Posts: 5
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by hdawg View Post
Its actually pretty straight forward ... How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instance

going to 2000 / 2005 couldn't be easier ... as long as you follow EACH AND EVERY STEP ... don't go thinkin you can skip stuff like I did the first time I tried

... its not just a simple backup and restore though.
Thanks for the information, I am trying a test run prior to the cutover date.

When I execute the restore statement I am getting the following error:

Logical file 'XXXXXX' is not part of database 'XXXXX'. Use RESTORE
FILELISTONLY to list the logical file names.

I skipped step 4 because I did create a default database when I installed BES on the new server, however the database I am backing up and restoring does not have the default name of BESMgmt? Is that why I am erroring out? Do I need to create a database with the name of the one that is being restored on the new SQL server prior to the restore?

Thanks again
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.