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



Reply
LinkBack (1) Thread Tools Display Modes
KB05041 - How to move the BlackBerry Configuration Database to a remote Microsoft SQL
 
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 03-27-2009, 04:11 AM
Si's Avatar
Si Si is offline
Proprietor
 
Join Date: Nov 2008
Location: London, UK
Posts: 1,046
Blog Entries: 6
Default KB05041 - How to move the BlackBerry Configuration Database to a remote Microsoft SQL

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

Environment

  • BlackBerry® Enterprise Server software version 4.0 Service Pack 2 (4.0.2) to 4.1 Service Pack 6 (4.1.6)
  • Microsoft® SQL Server® Desktop Engine (MSDE)
  • Microsoft® SQL Server® 2000, 2005 and 2005 Express Edition
  • SDR126288



Overview

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, you can use Microsoft tools that 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 will delay 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 BlackBerry Enterprise Server.
  3. Create a folder named DB-Backup on the root drive C.
  4. Run the 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 you 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 Required Permissions" section in the BlackBerry Enterprise Server version 4.0: Installation Guide or "Setting up the database connection" in the BlackBerry Enterprise Server version 4.1: Installation 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. Run BlackBerryDbRestore.exe. The following is an example of usage:
    BlackBerryDbRestore.exe -d BESMgmt -f C:\DB-Backup\BESMgmt20050919170203.bak -S -E
    where is the destination server (for instance, if you run 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.
  3. When the BlackBerry Configuration Database restoration completes, open BlackBerry Manager.
  4. Go to Tools > Options and select Database.
  5. 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 you stopped prior to performing the backup.
Confirm that all BlackBerry Enterprise Server services start without errors. After email message flow tests run without problems, you can shut down the Microsoft SQL Server hosting the original BlackBerry Configuration Database.

Additional Information

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 -
__________________
Si MCTS
Co-Owner
Port3101 - Your BES Connection

Don't forget, you can follow us on Twitter

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
Reply With Quote
Sponsored Links
Reply

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


LinkBacks (?)
LinkBack to this Thread: http://www.port3101.org/featured-blackberry-kb-articles/772-kb05041-how-move-blackberry-configuration-database-remote-microsoft-sql.html
Posted By For Type Date
New BES Server / New Hardware - BlackBerryForums.com : Your Number One BlackBerry Community This thread Refback 06-24-2009 01:12 PM

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
KB13732 - How to move from a local to a remote BlackBerry Router service hdawg Featured BlackBerry KB Articles 1 09-20-2009 04:24 PM
KB10669 - How to Move the BlackBerry Configuration Database for Domino hdawg Featured BlackBerry KB Articles 0 09-02-2009 09:51 PM
KB04296 - Move from a local to a remote attachment server Si Featured BlackBerry KB Articles 0 11-25-2008 10:44 AM


All times are GMT -4. The time now is 10:52 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2