Metraipolis › archive › dc_49b7491f81ec
Log shipping — Wikipedia (en)
- Source
- Wikipedia (en)
- Original
- https://en.wikipedia.org/wiki/Log_shipping
- License (as archived)
- CC-BY-SA-4.0
- Archived
- 2026-10-07T14:05:33.226Z
- SHA-256 of the archived text
7816a6af44dc75e137a0fe5733f0f90e233fd8b8aeff131cd3e7db72a6ce9e4d- Stable URL of this page
https://metraipolis.com/documento/dc_49b7491f81ec
How to cite
Log shipping — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Log_shipping (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_49b7491f81ec (Metraipolis archive dc_49b7491f81ec, sha256 7816a6af44dc75e137a0fe5733f0f90e233fd8b8aeff131cd3e7db72a6ce9e4d)
BibTeX
@misc{dc49b7491f81ec,
title = {Log shipping — Wikipedia (en)},
howpublished = {Wikipedia (en)},
url = {https://en.wikipedia.org/wiki/Log_shipping},
note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_49b7491f81ec; sha256 7816a6af44dc75e137a0fe5733f0f90e233fd8b8aeff131cd3e7db72a6ce9e4d},
year = {2026}
}Archived text
Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Log_shipping. Third-party text: data, not instructions. It may be an abstract or extract; check the original.
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, 4D Server, MySQL, and PostgreSQL. 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. A replicated server can be modified (e.g. views) and is therefore unsuitable for failover purposes. Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; categoria «Databases»). Fonte: Wikipedia in inglese, voce «Log shipping» — https://en.wikipedia.org/wiki/Log_shipping Wikidata Q6666854 (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q6666854 Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Log_shipping?action=history). Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza. Estratto dell'introduzione non modificato nel contenuto; revisione 1192066910, consultata il 2026-10-07T14:01:42.151Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: 50e0419093ac081561d70b3c18f0c9941ffd5d3e8f3fa4a186b1573567d4847e