Administration Guide

Local Navigation

Configuring the BlackBerry Configuration Database for one-way transactional replication in an environment that includes Microsoft SQL Server 2005 or 2008

Stop the BlackBerry Enterprise Server or BlackBerry MDS Integration Service instances

To maintain database integrity, you must prevent all services that use the BlackBerry® Configuration Database or BlackBerry MDS Integration Service database from connecting to the databases while you configure replication.
Perform any of the following actions:

Task

Step

Stop the services that use the BlackBerry Configuration Database.

  1. On the computers that host the BlackBerry® Enterprise Server components, in the Windows® Services, stop all of the BlackBerry Enterprise Server services in the following order:
    • BlackBerry Administration Service services
    • BlackBerry Mail Store Service
    • BlackBerry MDS Integration Service
    • BlackBerry Instant Messaging Connector
    • BlackBerry MDS Connection Service
    • BlackBerry Dispatcher
    • BlackBerry Attachment Service
    • BlackBerry Controller
    • all of the remaining BlackBerry Enterprise Server services that connect to the BlackBerry Configuration Database
  2. Repeat step a for each BlackBerry Enterprise Server component that connects to the BlackBerry Configuration Database.

Stop the services that use the BlackBerry MDS Integration Service database.

  1. On the computers that host the BlackBerry MDS Integration Service instances, in the Windows Services, stop the BlackBerry MDS Integration Service.

Create the replicated BlackBerry Configuration Database from a backup

Before you begin: Back up the BlackBerry® Configuration Database with the Backup type option set to Full.
  1. Copy the backup file from the database server that hosts the BlackBerry® Configuration Database to the database server that will host the replicated BlackBerry Configuration Database.
  2. In the Microsoft® SQL Server® Management Studio, in the left pane, navigate to the database server that will host the replicated BlackBerry Configuration Database.
  3. Right-click Database. Click Restore Database.
  4. Select From device.
  5. Navigate to the backup file that you copied from the database server that hosts the BlackBerry Configuration Database.
  6. Click OK.
  7. In the To database drop-down list, select the BlackBerry Configuration Database.
  8. In the list of backup sets to restore, select the backup file.
  9. Click Options.
  10. Select Overwrite the existing database.
  11. Click OK.

Permit access to the BlackBerry Configuration Database instances

  1. In the Microsoft® SQL Server® Management Studio, connect to the database server that hosts the BlackBerry® Configuration Database.
  2. Right-click the BlackBerry Configuration Database. Click Properties.
  3. Click Options.
  4. In the State section, in the Restrict Access drop-down list, select Multiple.
  5. Click OK.
  6. Repeat steps 1 to 5 for the replicated BlackBerry Configuration Database.

Configure the publication for the BlackBerry Configuration Database

  1. In the Microsoft® SQL Server® Management Studio, in the left pane, navigate to the database server that hosts the BlackBerry® Configuration Database.
  2. Click Replication.
  3. Right-click Local Publications. Click New Publication.
  4. If the Welcome dialog box appears, click Next.
  5. If this is the first time that you are configuring a publication on the database server, perform the following actions:
    • Select <database_server> will act as its own Distributor. Click Next.
    • In the Snapshot folder field, type the network location of the snapshot folder. Click Next.
  6. In the list of databases, select the BlackBerry Configuration Database name. Click Next.
  7. Click Transactional publication. Click Next.
  8. In the Objects to publish list, select Tables, Stored Procedures, Views, and User Defined Functions.
  9. If you installed the BlackBerry database notification system on the computer, expand Tables and clear the ServiceConfig table and the ServiceTable table. Click Next.
  10. If the Article Issues dialog box appears, click Next.
  11. If the Filter Table Rows dialog box appears, click Next.
  12. Select Schedule the Snapshot Agent to run at the following times.
  13. Accept or change the default schedule. Click Next.
  14. On the Snapshot Agent Security page, click Security Settings.
  15. Select Run under the following Windows account.
  16. Type the user name and password of a domain account that has local administrative permissions.
  17. Select By impersonating the process account.
  18. Click OK. Click Next.
  19. Select Create the publication. Click Next.
  20. In the Publication name field, type a name for the publication.
  21. Click Finish.
After you finish: Verify that you can access the shared snapshot folder from both database servers.

Prepare the database server that hosts the replicated BlackBerry Configuration Database and configure the subscription

  1. In the Microsoft® SQL Server® Management Studio, in the left pane, connect to the database server that hosts the replicated BlackBerry® Configuration Database.
  2. Navigate to the database server that hosts the replicated BlackBerry Configuration Database.
  3. Click Replication.
  4. Right-click Local Subscriptions. Click New Subscription.
  5. In the list of publishers, select the name of the database server that hosts the BlackBerry Configuration Database.
  6. In the list of databases and publications, select the publication for the BlackBerry Configuration Database. Click Next.
  7. Select Run each agent at its Subscriber (pull subscriptions). Click Next.
  8. In the Subscriber column, select the database server that hosts the replicated BlackBerry Configuration Database.
  9. In the Subscription Database drop-down list, select the replicated BlackBerry Configuration Database. Click Next.
  10. Change the distribution agent security so that you can access the Snapshot Agent using a Windows® account with administrative permissions on the domain.
  11. Select By impersonating the process account.
  12. Click OK. Click Next.
  13. In the Agent Schedule drop-down list, select Run continuously. Click Next.
  14. In the Subscription properties, clear Initialize. Click Next.
  15. Select Create the Subscriptions. Click Next.
  16. Click Finish.

Start the BlackBerry Enterprise Server or BlackBerry MDS Integration Service instances

After you configure the database, permit all BlackBerry® Enterprise Server or BlackBerry MDS Integration Service instances to connect to the principal BlackBerry Configuration Database or BlackBerry MDS Integration Service database.
Perform any of the following actions:

Task

Step

Start the services that use the BlackBerry Configuration Database.

  1. On the computers that host the BlackBerry Enterprise Server components, in the Windows® Services, start all of the BlackBerry Enterprise Server services in the following order:
    • BlackBerry Controller
    • BlackBerry Router
    • BlackBerry Attachment Service
    • BlackBerry Dispatcher
    • BlackBerry MDS Connection Service
    • BlackBerry Instant Messaging Connector
    • BlackBerry MDS Integration Service
    • BlackBerry Alert
    • BlackBerry Mail Store Service
    • BlackBerry User Administration Service
    • all of the remaining BlackBerry Enterprise Server services
  2. Repeat step a for each BlackBerry Enterprise Server component that connects to the BlackBerry Configuration Database.

Start the services that use the BlackBerry MDS Integration Service database.

  1. On the computers that host the BlackBerry MDS Integration Service instances, in the Windows Services, start the BlackBerry MDS Integration Service.

Was this information helpful? Send us your comments.