Log Shipping - Database Reference Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License

Microsoft SQL Server provides the ability to use log shipping, which can increase a database's availability by automatically copying and restoring the database transaction logs to another database on a standby server.

The standby server receives all changes made to the original database. Therefore, it is an exact duplicate of the original database that is out of date only by the delay in the copy-and-load process.

This failover solution does involve manual intervention. In the event that the server on which the original database resides becomes unavailable, the database administrator must perform steps to bring the standby server online.

For more information on log shipping, see the following Microsoft documents: