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


We are trying to do log shipping between two database servers where the system time set in destination server 24 hours ago What is the source system time can be forced to restore data to the destination machine (neglected transaction file tickets 24 hours ahead).

How about a snapshot @ 00:00 (or 23:59:59) daily? Then you can compare those days, though without any mechanism as you would like to log in to play. I'm a big fan of snapshots (just be careful, where you put files on the disk if it's a busy DB).

How to do this here:


Comments

Popular posts from this blog

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

asp.net mvc - Dynamically Generated Ajax.BeginForm -

Debug on symbian -