Administration Guide

Local Navigation

Configuring database mirroring

You can use Microsoft® SQL Server® 2005 or 2008 database mirroring to configure the BlackBerry® Configuration Database for high availability.

The BlackBerry Configuration Database only supports 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 instances

To maintain database integrity, you must prevent all services that use the BlackBerry® Configuration Database from connecting to the databases while you configure replication.
  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 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 1 for each BlackBerry Enterprise Server component that connects to the BlackBerry Configuration Database.
Back To Top

Configure database mirroring for the BlackBerry Configuration 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. Change the Backup type option to Full and back up the principal database.
  3. Copy the backup files to the database server that you want to have host the mirror database.
  4. 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.
  5. On the principal database, in the Database Properties window, on the Mirroring page, run the Configure Security wizard.
  6. Start the mirroring process.
  7. 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.
Back To Top

Start the BlackBerry Enterprise Server instances

After you configure the database, permit all BlackBerry® Enterprise Server instances to connect to the principal 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 Alert
    • BlackBerry Mail Store Service
    • BlackBerry User Administration Service
    • all of the remaining BlackBerry Enterprise Server services
  2. Repeat step 1 for each BlackBerry Enterprise Server component that connects to the BlackBerry Configuration Database.
Back To Top

Configure the BlackBerry Enterprise Solution to support database mirroring

When you configure the BlackBerry® Enterprise Solution to support database mirroring, the BlackBerry Administration Service adds a registry key to all of the computers that host BlackBerry® Enterprise Server components in the BlackBerry Domain and the registry key includes the name of the Microsoft® SQL Server® that hosts the mirror database. The BlackBerry Administration Service also adds the name of the Microsoft SQL Server that hosts the mirror database to the BlackBerry Configuration Database.

CAUTION:
If you click Save all more than once but you do not restart the BlackBerry Enterprise Server services or the computers that host the BlackBerry Enterprise Server components that the BlackBerry Administration Service specifies as Updated, you should restart the BlackBerry Enterprise Server services or restart the computers for all of the BlackBerry Enterprise Server components.
Before you begin: The database server that hosts the mirror database must be running.
  1. In the BlackBerry Administration Service, on the Servers and components menu, go to BlackBerry Solution Topology > BlackBerry Domain.
  2. Click Edit domain.
  3. In the Database mirroring turned on drop-down list, click Yes.
  4. In the Mirroring database host field, type the name of the mirror database server.
  5. Click Save all.
  6. On the computers that host the BlackBerry Enterprise Server components that are specified as Updated in the Server responses to mirroring data update table, restart the BlackBerry Enterprise Server services or restart the computers that host the components.
  7. On the computers that host the BlackBerry Enterprise Server components that are specified as No response. Please save the data again to attempt to update this server, verify that the computers are running and connected to the network and then resend the database mirroring parameters to the BlackBerry Enterprise Server components.
Back To Top

Resend the database mirroring parameters to BlackBerry Enterprise Server components

If the computers that host BlackBerry® Enterprise Server components were not running or connected to the network when you configured the BlackBerry® Enterprise Solution to support database mirroring, or if you do not know if all of the components were configured to support database mirroring, you should resend the database mirroring parameters to the components. When you resend the database mirroring parameters, the BlackBerry Administration Service adds a registry key to the computers that host the components. The registry key includes the name of the Microsoft® SQL Server® that hosts the mirror database.

CAUTION:
If you resend the database mirroring parameters more than once but you do not restart the BlackBerry Enterprise Server services or the computers that host the BlackBerry Enterprise Server components that the BlackBerry Administration Service specifies as Updated, you should restart the BlackBerry Enterprise Server services or restart the computers for all of the BlackBerry Enterprise Server components.
Before you begin: The database server that hosts the mirror database must be running.
  1. In the BlackBerry Administration Service, on the Servers and components menu, go to BlackBerry Solution Topology > BlackBerry Domain.
  2. Click Resend database mirroring parameters.
  3. On the computers that host the BlackBerry Enterprise Server components that are specified as Updated in the Server responses to mirroring data update table, restart the BlackBerry Enterprise Server services or restart the computers that host the components.
  4. On the computers that host the BlackBerry Enterprise Server components that are specified as No response. Please save the data again to attempt to update this server, verify that the computers are running and connected to the network and then resend the database mirroring parameters to the BlackBerry Enterprise Server components.
Back To Top

Was this information helpful? Send us your comments.