Skip Navigation

Create and configure the mirror database

To maintain database integrity while you create and configure the mirror database, stop the
BlackBerry UEM
services on every computer that hosts a
BlackBerry UEM
instance.
  1. In
    Microsoft SQL Server Management Studio
    , browse to the principal database.
  2. Change the
    Recovery Model
    property to
    FULL
    .
  3. In the query editor, run the
    -- ALTER DATABASE
    <BUEM_db>
    SET TRUSTWORTHY ON
    query, where
    <BUEM_db>
    is the name of the principal database.
  4. Back up the principal database. Change the
    Backup type
    option to
    Full
    .
  5. Copy the backup files to the mirror server.
  6. On the mirror server, restore the database to create the mirror database. When you restore the database, select the
    NO RECOVERY
    option.
  7. Verify that the name of the mirror database matches the name of the principal database.
  8. 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.
  9. To enable automatic failover, add a witness to the mirroring session. For more information, see Database Mirroring Witness – SQL Server 2012 or Database Mirroring Witness – SQL Server 2014.
  • To verify that failover works correctly, manually fail over service to the mirror database and back to the principal database.
  • Restart the
    BlackBerry UEM
    services on every computer that hosts a
    BlackBerry UEM
    instance.