Configure database mirroring
The
following instructions apply to Microsoft SQL
Server 2008 R2 and Microsoft SQL
Server 2012. The steps might be different based on your organization’s
version of Microsoft SQL
Server. Configure database mirroring for the BlackBerry Configuration Database first, and then configure database mirroring for the Management Database.
Before you begin: Visit technet.microsoft.com/sqlserver to read Database Mirroring - SQL Server 2008 R2 or
Database Mirroring - SQL Server 2012.
- In Microsoft SQL Server Management Studio, browse to the principal database.
- Change the Recovery Model property to FULL.
- In the query editor, run the -- ALTER DATABASE <BES_db> SET TRUSTWORTHY ON query, where <BES_db> is the name of the principal database (for example, BESMgmt).
- Back up the principal database. Change the Backup type option to Full.
- Copy the backup files to the mirror server.
- On the mirror server, restore the database to create the mirror database. When you restore the database, select the NO RECOVERY option.
- Verify that the name of the mirror database matches the name of the principal database.
- On the principal server, in Microsoft SQL Server Management Studio, right-click the principal database and select the Mirror task. On the Mirroring page, click Configure Security to launch the Configure Database Mirroring Security wizard.
- Start the mirroring process. For more information, see Setting up Database Mirroring – SQL Server 2008 R2 or Setting Up Database Mirroring – SQL Server 2012.
- To enable automatic failover, add a witness to the mirroring session. For more information, see Database Mirroring Witness – SQL Server 2008 R2 or Database Mirroring Witness – SQL Server 2012.
After you finish:
- After you configure database mirroring for the BlackBerry Configuration Database, configure database mirroring for the Management Database.
- To verify that failover works correctly, manually fail over service to the mirror database and back to the principal database.