17 Juli 2012

General Overview of Log Shipping


Log shipping technology is easy to configure and helps provides a strong database,
high availability strategy.
In principle, its possible for you to log ship to the same SQL Server,
but in reality, it should be on a separate physical server.
The basic process involves backing up the primary database to the secondary system
and constantly restoring transaction log backups.
This is shown in Figure 27-1.


Source:
Microsoft SQL 2005 Administrator's Companion,
Chapter 27 - Log Shipping and Database Mirroring
Page 873