Log shipping is a disaster recovery solution for SQL Server that involves copying and restoring transaction log backups from a primary database server to one or more secondary database servers. The purpose of log shipping is to maintain a warm standby database on a secondary server that can be quickly activated in the event of a primary server failure or disaster.
Here's how log shipping works:
On the primary server, transaction logs are backed up and copied to a shared location that is accessible by the secondary server.
On the secondary server, the transaction logs are restored to a standby database, which is kept in a recovery mode that allows additional transaction logs to be applied as they become available.
The secondary database can be configured to stay in a read-only state or in standby mode, which allows users to query the database, but not modify it.
In the event of a primary server failure or disaster, the secondary database can be activated, and users can begin using it for read and write operations.
No comments:
Post a Comment