How to move the BlackBerry Configuration Database from one server to another for IBM Lotus Domino

• BlackBerry® Enterprise Server 4.0 and 4.1 for IBM® Lotus® Domino®
• Microsoft® SQL Server
  

To move the BlackBerry Enterprise Server Configuration Database to another Microsoft® SQL Server™ or from Microsoft SQL Server Desktop Engine (MSDE) to a Microsoft SQL Server, it is recommended to first copy down the Server Routing Protocol (SRP) ID, SRP authentication key and Client Access License (CAL).

Note: Please make sure that the appropriate Microsoft SQL Server permissions are in place before starting. For more information on required Microsoft SQL Server permissions, please see the BlackBerry Enterprise Server for IBM Lotus Domino Installation Guide.

Important: Restarting certain BlackBerry Enterprise Server services will delay email message delivery to BlackBerry smartphones. For more information, see KB04789.

Complete the following steps:

1. Stop all instances of the BlackBerry Enterprise Server that are connected to the BlackBerry Configuration Database.
2. Back up the BlackBerry Configuration Database by completing one of the following two procedures:

   In Microsoft SQL Server Enterprise Manager

   1. Right-click the BlackBerry Configuration Database name (for example, BESMgmt) and click All Tasks.
   2. Select Backup Database.
   3. Click Add and specify a backup directory and file name.
   4. Click OK.
   5. Click OK again to create the backup.

   In a command prompt

   1. Type osql -E and press ENTER.
   2. Type the following commands in the specified order:

      1> backup database <database_name> to disk = 'C:\<database_name>.bak'

        where <database_name> is the name of the BlackBerry Configuration Database (for example, BESMgmt).

      2> go

      1> quit

   3. Close the command prompt window.
   4. Stop the Microsoft SQL Server service for the current Microsoft SQL Server.
3. Create a new, blank BlackBerry Configuration Database.  This step is needed in order to update the schema of the new Microsoft SQL Server. This database will be deleted later.
   1. On the BlackBerry Enterprise Server, go to Start > Programs > BlackBerry Enterprise Server > BlackBerry Server Configuration.
   2. On the Database tab, select Change Database.
   3. Enter the information for the new Microsoft SQL Server.
   4. Enter a name for the new database. This name must not match the name of the existing database.
   5. Complete the rest of the wizard, entering the SRP ID, authentication key, and CAL.
   6. Deselect the Start Services option.
4. Attach the new BlackBerry Configuration Database.
   1. Copy the MDF and LDF files from the original Microsoft SQL Server to the Data directory on the new computer.
   2. Attach the database by completing one of the following two procedures:

   In Microsoft SQL Server Enterprise Manager

   1. Right-click the BlackBerry Configuration Database folder and click All Tasks.
   2. Click Attach Database.
   3. In the <database_name>.mdf file, click OK.
   4. Click OK.

   In a command prompt

   1. Type osql -E and press ENTER.
   2. Type the following commands in the specified order:

      1> EXEC sp_attach_db @dbname = 'BESMgmt',

      2> @filename1 = "C:\Program Files\Microsoft SQL Server\MSSQL\Data\BESMgmt.mdf",

      3> @filename2 = "C:\Program Files\Microsoft SQL Server\MSSQL\Data\BESMgmt.ldf"

      4> go

      1> quit

   3. Close the command prompt.

5. Change the Database to point to the correct BlackBerry Configuration Database.
   1. On the BlackBerry Enterprise Server, go to Start > Programs > BlackBerry Enterprise Server > BlackBerry Server Configuration.
   2. On the Database tab, select Change Database.
   3. Enter the information for the new Microsoft SQL Server.
   4. Enter the correct BlackBerry Configuration Database name.
   5. Select the checkmark for the Start Services option.
   6. In the Open Database Connectivity (ODBC) Data Source Administrator of the Microsoft Administrative Tools, click the System DSN tab.
   7. From the System Data Sources, select the BlackBerry Configuration Database and click Configure.
   8. From the Which SQL server do you want to connect to? drop-down list, choose the correct MSDE or Microsoft SQL Server.
   9. Click Next and verify the other options are set correctly.
   10. When the ODBC Microsoft SQL Server Setup window appears, click Test Data Source to establish proper connectivity to the BlackBerry Configuration Database.
   11. After the process is complete, close the open windows.
6. Detach the blank database by completing one of the following two procedures:

   In SQL Server Enterprise Manager

   1. Right-click the BlackBerry Configuration Database name and click All Tasks.
   2. Click Detach Database.

   In a command prompt

   1. Type osql -E and press ENTER.
   2. Type the following commands in the specified order:

      1> exec sp_detach_db @dbname ="<database_name>"

      2> go

      1> quit

   3. Close the command prompt window.

If running BlackBerry Enterprise Server 4.1, install the Database Notification System by completing the following procedure:

1. Extract the BlackBerry Enterprise Server installation software to a temporary location.
2. Copy the RimEsp.dll file to C:\Program Files\Microsoft SQL Server\MSSQL\Binn.
3. In SQL Query Analyzer, browse to the \Database\DBInstallScripts\SQLServer\4.1 folder of the extracted installation software from Step 1.
4. Open the NotifyInstall.sql file and replace <_DATABASENAME_> with the name of the BlackBerry Configuration Database.
5. Run the NotifyInstall.sql script.

Note: Confirm the Query Analyzer displays the message ?Function dbo.xp_RIM_xxxx registered?.