At the secondary server , these transaction log backups are restored to the secondary database , keeping it in close synchronization with the primary database 。在辅助服务器中,这些事务日志备份还原到辅助数据库,使其与主数据库紧密同步。
Updates made by clients to the primary database are propagated by means of log shipping to the other copy of the database , known as the secondary database 通过日志传送将客户端对主数据库所做的更新传播到数据库的另一副本(称为辅助数据库) 。
Log shipping involves applying the transaction log from every insertion , update , or deletion made on the primary database onto the secondary database 日志传送涉及将由主数据库上执行的每个插入、更新或删除所组成的事务日志应用到辅助数据库上。
Restore backups of the principal primary database to other server instances to be later used as log shipping secondary databases for the primary database 将主体/主数据库的备份还原到其他服务器实例,后者以后将用作主数据库的日志传送辅助数据库。
Describes the effects of log shipping on replication behavior and the requirements and procedures for replicating from the secondary if the primary is lost 说明了日志传送对复制行为的影响,以及在丢失主数据库的情况下从辅助数据库进行复制的要求和过程。
If the accidental change is noticed quickly , a delay can let you retrieve still unchanged data from a secondary database before the change is reflected there 如果很快发现意外更改,则通过延迟,您可以在辅助数据库反映此更改之前从其中检索仍未更改的数据。
After the secondary servers are synchronized , you can fail over to whichever one you prefer by recovering its secondary database and redirecting clients to that server instance 同步辅助服务器之后,可以根据您的首选,通过恢复任一辅助数据库来故障转移该辅助服务器。
When the primary server of a log shipping configuration initially becomes unavailable , it is unlikely that all the secondary databases on the secondary servers are fully synchronized 当日志传送配置的主服务器开始不可用时,辅助服务器上的所有辅助数据库可能不会完全同步。
For information about the effects of log shipping on replication behavior and the requirements and procedures for replicating from the secondary if the primary is lost , see 有关日志传送对复制行为的影响以及在主数据库丢失时,从辅助数据库进行复制的要求和过程的信息,请参阅