How to back up and restore the BlackBerry Configuration Database

Article ID: KB10292

Type: Support Content

Last Modified: 10-03-2014

 

Product(s) Affected:

  • BlackBerry Enterprise Service 10
  • BlackBerry Enterprise Server
  • BlackBerry Device Service
  • Universal Device Service
CollapseEnvironment
  • BlackBerry Enterprise Server 3.6 to 5.0 SP4
  • BlackBerry Enterprise Service 10
  • BlackBerry Device Service
  • Universal Device Service
  • Microsoft SQL Server Desktop Engine (MSDE)
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
CollapseOverview

To back up the BlackBerry Configuration Database, complete the following steps:

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

  1. Stop the BlackBerry Enterprise Server services.
    Note: If a regular backup of the BlackBerry Configuration Database is performed, there is no need to stop these services.
     
  2. Back up the BlackBerry Configuration Database using one of the following two options and related steps:
     
    1. Option 1: Using Microsoft SQL Server Enterprise Manager or Microsoft SQL Server Management Studio, complete the following steps:
      1. Open Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 or 2008).
      2. Right-click the BlackBerry Configuration Database (for example, BESMgmt, BDSMgmt, BDSMgmt_UDS).
      3. Select Backup Database.
      4. Click Add to specify the Directory Name and File Name.
      5. Click OK to accept the settings.
      6. Click OK again to start the backup process.
      7. Close Enterprise Manager (Microsoft SQL Server 2000) or Microsoft SQL Server Management Studio (Microsoft SQL Server 2005 or 2008) when the process is complete.
         
    2. Option 2: Using command prompt, complete the following steps: 
      1. Open a command prompt, type one of the commands below, and press Enter to log in to the MSDE:
        • If Windows authentication with the default Microsoft SQL Server instance is used:
          OSQL -E
        • If Windows authentication with a named Microsoft SQL Server instance is used:
          OSQL -E -S server_name\instance_name
        • If Microsoft SQL Server authentication with the default Microsoft SQL Server instance is used:
          OSQL -U sa -P password
        • If Microsoft SQL Server authentication with a named Microsoft SQL Server instance is used:
          OSQL -U sa -P password -S server_name\instance_name
           
      2. Type the following commands in the exact order as seen below:
        1. backup database <BESMGMT> to disk="C:\<BESMGMT>.bak" where <BESMGMT> is the BlackBerry Configuration Database name.
        2. go
        3. quit

To restore the BlackBerry Configuration Database, complete the following steps:

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

  1. Stop the BlackBerry Enterprise Server services.
  2. Restore the BlackBerry Configuration Database by completing the one of the following options and related steps:
     
    1. Option 1: Using Microsoft SQL Server Enterprise Manager (SQL 2000) or Microsoft SQL Server Management Studio (SQL 2005 or 2008)
      1. Right-click the name of the BlackBerry Configuration Database (for example, BESMgmt) and select All Tasks.
      2. Select Restore Database.
      3. On the General tab, under the Restore heading, select From device.
      4. Click Select Devices.
      5. In Choose Restore Devices, select Add.
      6. In the File name field, browse to the backup file (for example, besmgmt.bak).
      7. Click OK.
      8. Select the check box for the database to be restored.
      9. Select Options on the Select a page section of the window.
      10. Select the Overwrite the existing database check box.
      11. Click OK.
      12. Click OK again.
         
    2. Option 2: Using a command prompt:
      1. Type one of the following commands in a command prompt and press ENTER to log into MSDE:
        • If Windows authentication with the default Microsoft SQL Server instance is used:
          OSQL -E
        • If Windows authentication with a named Microsoft SQL Server instance is used:
          OSQL -E -S server_name\instance_name
        • If Microsoft SQL Server authentication with the default Microsoft SQL Server instance is used:
          OSQL -U sa -P password
        • If Microsoft SQL Server authentication with a named Microsoft SQL Server instance is used:
          OSQL -U sa -P password -S server_name\instance_name
      2. Type the following commands in the exact order as seen below:
        1. restore database <BESMGMT> from disk="c:\ <BESMGMT>.bak" where <BESMGMT> is the BlackBerry Configuration Database name.
        2. go
        3. quit

For more information on restoring to different SQL server versions, see Task 3 section of KB03112.

CollapseAdditional Information

The default database names are as follows, although the actual name of the database being used may differ from the default name:

BlackBerry Enterprise Server 3.6 to 5.0 SP4:

  • BESMgmt

BlackBerry Enterprise Service 10.0:

  • BlackBerry Device Service: BDSMgmt
  • Universal Device Service: UDSMgmt

BlackBerry Enterprise Service 10.1 and later:

  • BlackBerry Device Service: BDSMgmt
  • Universal Device Service: BDSMgmt_UDS

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.