Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

3
  • What I was trying to achieve was a combination of data replication (which seems to be working), and the ability to restore from a backup to a point in time if required: the idea being I could use the last bak and subsequent transaction logs that were being backup up. Would using a differential backup be a better idea? Commented Nov 15, 2014 at 16:49
  • 2
    You would simply utilize the log backups from your log shipping process in order to restore to a point in time. Commented Nov 15, 2014 at 17:49
  • Perfect - that's cracked it. I've changed my bespoke process: instead of kicking off its own log backups every hour, it just grabs a copy of the .trn's from the log shipping directory instead. So I now have replication AND a bunch of bak and trn files to do restores from. Thanks! Commented Nov 16, 2014 at 9:41