BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 09-10-2007, 12:38 PM   #1
2001RK
New Member
 
Join Date: Jun 2007
Model: 8703e
PIN: N/A
Carrier: Sprint
Posts: 5
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
hdawg
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
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
2001RK
New Member
 
Join Date: Jun 2007
Model: 8703e
PIN: N/A
Carrier: Sprint
Posts: 5
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


64GB Rechargeable LCD Digital Audio Sound Voice Recorder Dictaphone MP3 Player picture

64GB Rechargeable LCD Digital Audio Sound Voice Recorder Dictaphone MP3 Player

$29.49



32G Voice Activated Mini Spy Digital Sound Audio Recorder Dictaphone MP3 Player picture

32G Voice Activated Mini Spy Digital Sound Audio Recorder Dictaphone MP3 Player

$24.69



Automatic Wrist Blood Pressure Monitor BP Cuff Gauge Machine Tester with Memory picture

Automatic Wrist Blood Pressure Monitor BP Cuff Gauge Machine Tester with Memory

$15.68



 Proxmark3 Easy V3 Kit 512k Memory PM3 ID M1 IC RFID Card Reader Writer Copier  picture

Proxmark3 Easy V3 Kit 512k Memory PM3 ID M1 IC RFID Card Reader Writer Copier

$119.22



2x Memory Foam Armrest Cushion Pads Elbow Arm Rest Cover Chair Armrest Pads picture

2x Memory Foam Armrest Cushion Pads Elbow Arm Rest Cover Chair Armrest Pads

$14.71



American Crafts We R Memory Keepers CINCH - BOOK BINDING TOOL - ROUND 71050-9 picture

American Crafts We R Memory Keepers CINCH - BOOK BINDING TOOL - ROUND 71050-9

$99.74







Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.