How to move the BlackBerry Configuration Database to a remote Microsoft SQL Server

Article ID: KB05041

Type: Support Content

Last Modified: 04-15-2014

 

Product(s) Affected:

  • BlackBerry Enterprise Server for Microsoft Exchange
  • BlackBerry Enterprise Server for IBM Lotus Domino
  • BlackBerry Enterprise Server for Novell GroupWise
  • BlackBerry Enterprise Server for Microsoft Office 365
CollapseEnvironment
  • BlackBerry Enterprise Server 4.0 SP2 to 5.0 SP4
  • BlackBerry Enterprise Server for Office 365
  • Microsoft Desktop Engine (MSDE)
  • Microsoft SQL Server 2000, 2005
CollapseOverview

This article outlines the procedure for moving the BlackBerry Configuration Database to a remote Microsoft SQL Server. The procedure requires tools provided with the BlackBerry Enterprise Server installation; however, the Microsoft tools can be used to perform the same functions.

Task 1 - Record Configuration Information

Before completing the other tasks, record the following information:

  • Client Access Licenses (CALs)
  • Server Routing Protocol Identifier (SRP ID)
  • SRP Authentication keys
  • Settings (including the Trusted Application key) from the GroupWise Settings tab in the BlackBerry Server Configuration Panel

Task 2 - Stop the BlackBerry Enterprise Server services

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

In the Windows Services administration tool, stop the following services:

  • BlackBerry Alert
  • BlackBerry Attachment Service
  • BlackBerry Controller
  • BlackBerry Dispatcher
  • BlackBerry Mobile Data Service
  • BlackBerry Policy Service
  • BlackBerry Router
  • BlackBerry Synchronization Service

Task 3 - Back up the BlackBerry Configuration Database

Complete the following steps:

  1. Open the Tools folder on the BlackBerry Enterprise Server installation disk.
  2. Copy the BlackBerryDbBackup.exe and BlackBerryDbRestore.exe files to a temporary folder on the SQL Server hosting the BlackBerry Configuration Database..
  3. Create a folder named DB-Backup on the root drive C.
  4. Navigate to the temporary folder that was created in Step 2 from a command prompt.
  5. Enter BlackBerryDbBackup.exe file. The following is an example of its usage at a command prompt:

BlackBerryDbBackup.exe -d BESMgmt -f C:\DB-Backup -E

This backs up the current BlackBerry Configuration Database using Windows Authentication.

Note: Refer to the table in the Additional Information section for more command line switches.

Task 4 - Create a New Configuration Database

Complete the following steps:

  1. Open the BlackBerry Server Configuration Panel.
  2. Select the Database Connectivity tab, and then click the Change Database button.
  3. When prompted, type the configuration information recorded prior to stopping the BlackBerry Enterprise Server services.

    Note: Specify the exact names for the new BlackBerry Configuration Database and the BlackBerry Enterprise Server.

  4. When the Configuration Wizard process is complete, clear the Start Services option.

To set the permissions required to create a BlackBerry Configuration Database on a remote Microsoft SQL Server, see the Configuring connections for the BlackBerry Enterprise Server database section in the BlackBerry Enterprise Server 5.0 Service Pack 4 Installation and Configuration Guide.

Task 5 - Restore the BlackBerry Configuration Database

Complete the following steps:

  1. Copy and paste the BlackBerry Configuration Database backup to the remote Microsoft SQL Server.
  2. Navigate to the folder the file was copied to in a command prompt.
  3. Enter BlackBerryDbRestore.exe in the command prompt window. The following is an example of usage:

    BlackBerryDbRestore.exe -d BESMgmt -f C:\DB-Backup\BESMgmt20050919170203.bak -S<new_SQL_Server> -E

    Where <new_SQL_Server> is the destination server (for instance, if running BlackBerryDbRestore.exe remotely from the BlackBerry Enterprise Server).

    This restores BlackBerry Configuration Database settings using Windows Authentication.

    Note: Refer to the table in the Additional Information section for more command line switches.

  4. When the BlackBerry Configuration Database restoration completes, open BlackBerry Manager.
  5. Go to Tools > Options and select Database.
  6. Make sure that the new Microsoft SQL Server name is listed in Database Server Name field. This setting is needed for local and remote installations of BlackBerry Manager.

Task 6 - Start the BlackBerry Enterprise Server services

After verifying BlackBerry smartphone user lists and settings are correctly restored to the new BlackBerry Configuration Database, start the BlackBerry Enterprise Server services that were stopped prior to performing the backup.

Confirm that all BlackBerry Enterprise Server services start without errors. After email message flow tests run without problems, the Microsoft SQL Server hosting the original BlackBerry Configuration Database can be shut down.

CollapseAdditional Information

Please note: BlackBerryDbBackup is not supported on SQL 2008 and newer.

The following table lists switches and descriptions for use with the BlackBerryDbBackup.exe and BlackBerryDbRestore.exe tools.

Switch Description Default
-d Specifies the database name -
-E Uses Windows Authentication False
-f Specifies the name of the folder where the backup file is placed. You must specify an existing folder on the computer running MSDE or the Microsoft SQL Server with the original BlackBerry Configuration Database Current folder
-P Specifies password “ “ (blank)
-p Specifies percentage increment to report progress 10%
-S Specifies BlackBerry Enterprise Server instance name Local name.
-U Specifies user name sa
-? Specifies help and usage information -

Disclaimer

By downloading, accessing or otherwise using the Knowledge Base documents you agree:

   (a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and

   (b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.


Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.