Categories
High Availability

Log shipping – Sql2005

Log shipping allows you to automatically send transaction log backups from one database (known as the primary database) to a secondary database on another server (known as the secondary server). At the secondary server, these transaction log backups are restored to the secondary database, keeping it closely synchronized with the primary database. An optional third server, known as the monitor server, records the history and status of backup and restores operations and optionally raises alerts if these operations fail to occur as scheduled.

Categories
High Availability

Comparison between Mirroring VS Log shipping and Mirroring VS Clustering

Database Mirroring Vs Clustering