Enabling Transaction Log Mirroring

(Recommended) Enable transaction log mirroring, if your backup strategy requires it. Mirror the transaction log files using the dblog command line utility to store the primary and mirror transaction logs on separate drives from the database file.

1. Identify the target destination for transaction logs.
   The drive letter cannot be to a substituted drive.
2. From a command prompt, run:

   dblog -t c:\transaction_file.log -m m:\mirror_file.log db_name.db
   

• Transaction Log Mirrors
  A transaction log mirror is an identical copy of the transaction log. If a database has a transaction log mirror, every database change is written to both the transaction log and the transaction log mirror.