Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB10669 - How to Move the BlackBerry Configuration Database for Domino
 
  #1 (permalink)  
Old 09-02-2009, 09:51 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB10669 - How to Move the BlackBerry Configuration Database for Domino

KB10669 - How to Move the BlackBerry Configuration Database from one server to another for IBM Lotus Domino


Environment

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



Overview

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, you first need to copy down your Server Routing Protocol (SRP) ID, 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, 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:\.bak'
      where 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 .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.



Additional Information

If running BlackBerry Enterprise Server version 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 your BlackBerry Configuration Database.
  5. Run the NotifyInstall.sql script.
  6. Confirm the Query Analyzer displays the message ?Function dbo.xp_RIM_xxxx registered?.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

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 On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
KB18129 - Switching BlackBerry Configuration Database in BES 5.0 hdawg Featured BlackBerry KB Articles 1 03-27-2010 10:59 AM
KB12247 - Move from an MSDE database to a Microsoft SQL Server database hdawg Featured BlackBerry KB Articles 2 09-24-2009 04:25 PM
KB10292 - How to back up and restore the BlackBerry Configuration Database Si Featured BlackBerry KB Articles 4 09-21-2009 09:10 PM
KB05041 - How to move the BlackBerry Configuration Database to a remote Microsoft SQL Si Featured BlackBerry KB Articles 0 03-27-2009 04:11 AM
KB03968 - How to increase or decrease the BlackBerry Configuration Database..... Si Featured BlackBerry KB Articles 1 01-15-2009 12:38 PM


All times are GMT -4. The time now is 01:34 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2