Administration Guide

Local Navigation

Configuring database mirroring

You can use Microsoft® SQL Server® 2005 or 2008 database mirroring to configure the BlackBerry® Configuration Database or the BlackBerry MDS Integration Service database for high availability. You can configure database mirroring with or without a witness.

The BlackBerry Configuration Database and the BlackBerry MDS Integration Service database only support high safety with automatic failover (synchronous) operating mode for database mirroring.

For more information, visit http://msdn2.microsoft.com/en-us/library/ms175059(SQL.90).aspx.

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.

Configure database mirroring for the BlackBerry Configuration Database or BlackBerry MDS Integration Service database

For more information about database mirroring, visit http://msdn2.microsoft.com/en-us/library/ms175059(SQL.90).aspx.
  1. In the Microsoft® SQL Server® Management Studio, change the Recovery Model property for the principal database to Full.
  2. In the query editor, run the -- ALTER DATABASE <BESMgmt> SET TRUSTWORTHY ON query, where <BESMgmt> is the name of the BlackBerry® Configuration Database or BlackBerry MDS Integration Service database.
  3. Change the Backup type option to Full and back up the principal database.
  4. Copy the backup files to the database server that you want to have host the mirror database.
  5. On the database server that will host the mirror database, restore the database. If you did not perform a full backup, specify the NO RECOVERY option.
  6. On the principal database, in the Database Properties window, on the Mirroring page, run the Configure Security wizard.
  7. Start the mirroring process.
  8. To verify that failover works correctly, fail over to the mirror database and back to the principal database manually.
After you finish: To permit the mirror BlackBerry Configuration Database to write BlackBerry® Enterprise Server event messages, install the BlackBerry database notification system on the database server that hosts the mirror BlackBerry Configuration Database. For more information, see the BlackBerry Enterprise Server Installation Guide.

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.

Configure the BlackBerry Enterprise Server to support database mirroring

If you did not specify the mirror database server during the installation process, you must configure the BlackBerry® Enterprise Server to support database mirroring.
Before you begin: The database server that hosts the mirror database must be running.
  1. On the computer that hosts the BlackBerry Enterprise Server, on the Start menu, click Run.
  2. Type regedit.
  3. Click OK.
  4. Perform one of the following actions:
    • If you are running a 32-bit version of Windows, navigate to HKEY_LOCAL_MACHINE\Software\Research In Motion\BlackBerry Enterprise Server\Database.
    • If you are running a 64-bit version of Windows, navigate to HKEY_LOCAL_MACHINE\Software\WOW6432Node\Research In Motion\BlackBerry Enterprise Server\Database.
  5. Create a String value that is named FailoverServerMachineName.
  6. Specify the name of the mirror database server as the value.
  7. In the Windows® Services, restart all of the BlackBerry Enterprise Server services.
After you finish:

Configure the BlackBerry Enterprise Server to fail over automatically.


Was this information helpful? Send us your comments.