Post reply

Info needed on LSN values

  • March 18, 2011 at 12:34 am

    #233355

    I executed the dbcc opentran and got below information. Can anyone please let me know what exactly the LSN value 41:137:1

    Replicated Transaction Information:

    Oldest distributed LSN : (41:16:3)

    Oldest non-distributed LSN : (41:137:1)

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    Thanks in advance

    ~VK 🙂

  • March 18, 2011 at 3:26 am

    #1300352

    LSN is a log sequence number, it's kinda the address/identifier for a log record.

    What are you trying to do/find here?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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