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
- 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
- Repeat step 1 for each BlackBerry Enterprise Server component that connects to the BlackBerry Configuration Database.
Configure database mirroring for the BlackBerry Configuration Database
- In the Microsoft® SQL Server® Management Studio, change the Recovery Model property for the principal database to Full.
- Change the Backup type option to Full and back up the principal database.
- Copy the backup files to the database server that you want to have host the mirror database.
- 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.
- On the principal database, in the Database Properties window, on the Mirroring page, run the Configure Security wizard.
- Start the mirroring process.
- To verify that failover works correctly, fail over to the mirror database and back to the principal database manually.
Start the BlackBerry Enterprise Server instances
- 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
- Repeat step 1 for each BlackBerry Enterprise Server component that connects to the BlackBerry Configuration Database.
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.
- In the BlackBerry Administration Service, on the Servers and components menu, go to BlackBerry Solution Topology > BlackBerry Domain.
- Click Edit domain.
- In the Database mirroring turned on drop-down list, click Yes.
- In the Mirroring database host field, type the name of the mirror database server.
- Click Save all.
- 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.
- 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.
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.
- In the BlackBerry Administration Service, on the Servers and components menu, go to BlackBerry Solution Topology > BlackBerry Domain.
- Click Resend database mirroring parameters.
- 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.
- 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.