Database mirroring requirements
Item |
Requirement |
---|---|
Microsoft SQL
Server |
BlackBerry UEM supports database mirroring using one of the following:
|
SQL Server Native Client |
The SQL Server 2012 Native Client must be installed on each computer that hosts a BlackBerry UEM instance. The BlackBerry UEM setup application installs the SQL Server 2012 Native Client. |
Version parity |
The Microsoft SQL
Server that hosts the mirror database must be the same version and edition as the Microsoft SQL
Server that hosts the principal database. |
Database location |
Make sure that the active copy of the mirror database is always in the local datacenter. |
Operating mode |
Configure database mirroring using high-safety mode with automatic failover. |
Witness |
A witness server is required for automatic failover. The witness must be a different server than the principal server and the mirror server. For more information, see Database Mirroring Witness – SQL Server 2012 or Database Mirroring Witness – SQL Server 2014. |