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


US Stock 10 Units 10K B10K OHM Linear Taper Rotary Potentiometer POT Blue Knob picture

US Stock 10 Units 10K B10K OHM Linear Taper Rotary Potentiometer POT Blue Knob

$8.99



100pcs 10 Value Potentiometer Trimpot Variable Resistor Assortment Box Kit RM065 picture

100pcs 10 Value Potentiometer Trimpot Variable Resistor Assortment Box Kit RM065

$8.75



US Stock 10 pcs 10K ohm Linear Taper Rotary Potentiometer Panel pot B10K 20mm picture

US Stock 10 pcs 10K ohm Linear Taper Rotary Potentiometer Panel pot B10K 20mm

$12.19



US Stock 10pcs 100K ohm Linear Taper Rotary Potentiometer Panel pot B100K 20mm picture

US Stock 10pcs 100K ohm Linear Taper Rotary Potentiometer Panel pot B100K 20mm

$12.17



US Stock 10 Units 1K B1K OHM Linear Taper Rotary Potentiometer POT  Orange Knob picture

US Stock 10 Units 1K B1K OHM Linear Taper Rotary Potentiometer POT Orange Knob

$7.99



10K Potentiometer 22mm Governor VSD VFD For Variable Speed Drive Inverter picture

10K Potentiometer 22mm Governor VSD VFD For Variable Speed Drive Inverter

$7.37







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