SQL Server 2008 中大型数据库日志传送的初始配置
我们有一个新的文件流数据库，最初将加载 65GB 数据，我们希望为其配置日志传送到远程（不同大陆）位置。
对于日志传送的初始设置，主数据库的备份和恢复到辅助数据库之间的时间是否有任何阈值？在我们配置日志传送之前，新数据库基本上将处于脱机状态。由于数据库的大小，数据库最初备份到在目标上恢复之间可能需要一段时间（天）。这会是一个问题吗？
We have a new filestream database that will be initially loaded with 65GB data, for which we'd like to configure log shipping to a remote (different continent) location.
For the initial setup of log shipping, is there any threshold for the time between the backup of the primary and it's restore onto the secondary? The new database will essentially be offline until we have the log shipping configured. Due to the size of the database, it may be some time (days) between the database initially being backed-up and then restored on the target. Will this be a problem?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我相信唯一担心的是日志序列号（LSN）链是否完整。这将从完整备份开始，但也可以根据需要进行任意数量的后续事务日志备份。您提到在配置日志传送之前数据库将处于脱机状态，因此在备份完成复制/恢复之前，在主数据库上建立事务不应该出现问题。但是，如果您想让主服务器联机，您可能必须频繁进行事务日志备份，以避免随着事务的积累而耗尽空间（取决于使用情况）。
这没关系，因为您可以轻松地将这些事务日志复制到辅助数据库，恢复它们，然后启用日志传送。只要在主服务器上进行的所有备份都已在辅助服务器上恢复，LSN 链就会得到维护，因此传送过来的第一个日志备份应该能够正确恢复。在这种情况下，时间并不重要。
I believe the only concern is that the Log Sequence Number (LSN) chain is unbroken. This will start with your full backup, but can also have as many subsequent transaction log backups as you need. You mentioned the database will be offline until the log shipping is configured, so you shouldn't have an issue with transactions building up on the primary until the backup finishes copy/restore. However, if you wanted to bring the primary online, you might have to take frequent transaction log backups to avoid running out of space as the transactions build up (depending on usage).
This is okay, because you could easily copy those transaction logs over to the secondary, restore them, then enable log shipping. As long as all the backups taken on the primary have been restored on the secondary, the LSN chain is maintained, so the first log backup that is shipped over should restore correctly. Time doesn't matter in this case.