开发者

Log Shipping - 24 hour difference between source and destination system times

开发者 https://www.devze.com 2022-12-19 02:23 出处:网络
We are trying to have log shipping work between two database servers where the destination开发者_运维技巧 server has a system time set 24 hours earlier than the source system time.Is it possible to fo

We are trying to have log shipping work between two database servers where the destination开发者_运维技巧 server has a system time set 24 hours earlier than the source system time. Is it possible to force the destination machine to restore the data (disregarding the transaction file stamps are 24 hours ahead).


How about a snapshot @ 00:00 (or 23:59:59) daily? Then you could compare the days however you want without a mechanism such as log shipping in play. I'm a big fan of Snapshots (just be careful where you put the files on disk if it's a busy DB).

Here's the How to: http://msdn.microsoft.com/en-us/library/ms175876.aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消