General Info

{{toc}}

h1. Database Mirroring on remote site

h2. Introduction

To mirror production database(s) to remote site, there are a number of approaches:

# Use <code>(full)</code> database backup

# Use <code>(full + incremental)</code> database backup

# Use <code>(full + delta)</code> database backup

# Use <code>(full + incremental + delta)</code> database backup - _not recommended because it is too complex_

# Use <code>(full database backup + transaction logs)</code>

> the approach 1-4 are described in "Using DB2 incremental backup":http://www.ibm.com/developerworks/data/library/techarticle/dm-0910db2incrementalbackup/

The following sections will describe how the last approach actually works. Before that, let's do a compare:

!database_mirroring_approach.png!

h2. Full Database Backup + Transaction Logs

Below diagram describes how this approach works:

!full_transaction_logs_approach.png!