RTaylor2208 (4/30/2014)

---

Given you requirement for minimal latency and no change to the recovery model I would say that your only option is transactional replication.

>Mirroring requires full recovery

>log shipping requires at least bulk logged recovery and it will require the DB to be in norecovery during the restores making the destination unaccessible.

> SSIS - You could use CDC but again this process may take one than 1 to 2 minutes to do the ETL and requires CDC enabled on the tables in your source DB you want to replicate.

>backup restore again will require the destination to be unavailable during your restore.