Log shipping is the process of automating the backup of transaction log files on a primary (production) database server, and then restoring them onto a standby server. This technique is supported by Microsoft SQL Server,[1]4D Server,[2]MySQL,[3] and PostgreSQL.[4][5] Similar to replication, the primary purpose of log shipping is to increase database availability by maintaining a backup server that can replace a production server quickly. Other databases such as Adaptive Server Enterprise and Oracle Database support the technique but require the Database Administrator to write code or scripts to perform the work.
Although the actual failover mechanism in log shipping is manual, this implementation is often chosen due to its low cost in human and server resources, and ease of implementation. In comparison, SQL server clusters enable automatic failover, but at the expense of much higher storage costs. Compared to database replication, log shipping does not provide as much in terms of reporting capabilities, but backs up system tables along with data tables, and locks the standby server from users' modifications.[6] A replicated server can be modified (e.g. views) and is therefore unsuitable for failover purposes.
Referencesedit
^How to Perform SQL Server Log Shipping 2009-01-04 at the Wayback Machine, "What is Log Shipping". Retrieved on 2008-12-16.
^"Setting Up a Logical Mirror". 4D Server v14 Documentation.
shipping, process, automating, backup, transaction, files, primary, production, database, server, then, restoring, them, onto, standby, server, this, technique, supported, microsoft, server, server, mysql, postgresql, similar, replication, primary, purpose, sh. Log shipping is the process of automating the backup of transaction log files on a primary production database server and then restoring them onto a standby server This technique is supported by Microsoft SQL Server 1 4D Server 2 MySQL 3 and PostgreSQL 4 5 Similar to replication the primary purpose of log shipping is to increase database availability by maintaining a backup server that can replace a production server quickly Other databases such as Adaptive Server Enterprise and Oracle Database support the technique but require the Database Administrator to write code or scripts to perform the work Although the actual failover mechanism in log shipping is manual this implementation is often chosen due to its low cost in human and server resources and ease of implementation In comparison SQL server clusters enable automatic failover but at the expense of much higher storage costs Compared to database replication log shipping does not provide as much in terms of reporting capabilities but backs up system tables along with data tables and locks the standby server from users modifications 6 A replicated server can be modified e g views and is therefore unsuitable for failover purposes References edit How to Perform SQL Server Log Shipping Archived 2009 01 04 at the Wayback Machine What is Log Shipping Retrieved on 2008 12 16 Setting Up a Logical Mirror 4D Server v14 Documentation MySQL MySQL 5 7 Reference Manual 17 1 Configuring Replication mysql com Warm Standby Servers for High Availability PostgreSQL 8 2 19 Documentation Hot Standby PostgreSQL Wiki Retrieved 2011 01 25 Ibison Paul Log Shipping vs Replication SQLServerCentral com Retrieved 2009 08 07 External links editLog Shipping MS SQL Server implementation Hot Standby PostgreSQL implementation nbsp This article related to a type of software is a stub You can help Wikipedia by expanding it vte Retrieved from https en wikipedia org w index php title Log shipping amp oldid 1192066910, wikipedia, wiki, book, books, library,
