Set up log shipping on the principal database as the primary database for one or more secondary databases 在用作一个或多个辅助数据库的主数据库的主体数据库上设置日志传送。
Describes how to use a secondary database for query processing , and the tradeoffs involved with doing this 说明如何使用辅助数据库进行查询处理以及进行此操作时用到的权衡关系。
Allows complete availability of the secondary databases for reporting or other functions , without query recovery 支持辅助数据库对报告或其他功能的完全可用性,而无需查询恢复。
Each secondary database is created by restoring a database backup of the primary database with no recovery , or with standby 通过还原但不恢复主数据库的完整备份可创建辅助数据库。
All transactions that log shipping copies from the secondary back to the primary are replicated to subscribers 所有由日志传送从辅助数据库复制回主数据库的事务均被复制到订阅服务器。
Each secondary server updates its secondary database at regular intervals from log backups of the primary database 每个辅助服务器从“主数据库”的日志备份以固定的时间间隔更新辅助数据库。
Restore a pre - existing backup of the primary database to the secondary server , creating the secondary database if necessary 如果需要的话,将现有的主数据库备份还原到辅助服务器,以创建辅助数据库。
In a log shipping configuration , database snapshots can be created only on the primary database , not on a secondary database 在日志传送配置中,只能针对主数据库,而不能针对辅助数据库创建数据库快照。
If a failover occurs , replication agents do not connect to the secondary , so transactions are not replicated to subscribers 如果发生故障转移,复制代理不连接到辅助数据库,因此不将事务复制到订阅服务器。
If a primary contains more than one publication database , log ship all of the publication databases to the same secondary 如果主数据库包含多个发布数据库,则将所有发布数据库日志传送到同一个辅助数据库。