Create and configure the mirror database

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

<BUEM_db>

SET TRUSTWORTHY ON

query, where

<BUEM_db>

is the name of the principal database.

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 2012 or Setting Up Database Mirroring – SQL Server 2014.

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.