Post reply

Log Shipping - What has changed

  • December 9, 2019 at 9:32 am

    #3705928

    We currently have a situation with a vendor where they will only give us access to our data via 5 minute log ship files that we import into our read only db. this is fine for most queries, but we need a way to get details about what has changed in each period in the most efficient manner possible.

    Usually we would go to triggers and update another table, but we cant do that.

    Then we would try change data capture, cant do that either.

    What options are out there to get the changes?

    Can we read the log files themselves to parse out changes?

    Thanks for any help

    Nick

  • December 9, 2019 at 9:53 am

    #3705932

    https://www.mssqltips.com/sqlservertip/3076/how-to-read-the-sql-server-database-transaction-log/

    that might help

    MVDBA

  • December 10, 2019 at 3:46 pm

    #3706549

    A little left-field, but a snapshot backup just before the log file ships and then running a data compare (such as redgate's SQL Data Compare) between the snapshot and the original DB, after the log file has been processed, might give you what you need.

    Steve Hall
    Linkedin
    Blog Site

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply