Post reply

Log Shipping Problem

  • September 29, 2009 at 8:28 am

    #138351

    Hi All,

    I have a master and a target server for log shipping.

    Target Server is on Stanby Mode.

    While querying count on a table from target server (standby server) i do not have same count number from master database on same table?

    Everything is OK. Backup Transaction Log is OK, COPY Transaction Log is OK, and Last Restored Transaction Log is OK. ALL LSN are Same.

    Why does it occur?

  • September 29, 2009 at 8:46 am

    #1059514

    that may happen if there are inserts/deletes going on in the primary database. Until the log is backed up next, copied and restored on the secondary, there will be difference in the record count.


    Pradeep Singh

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

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