Move X amount of users from one environment to another with diff SQL versions.
 

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

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 :razz:

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