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
精彩评论