locked
Log Sequence Number RRS feed

  • Question

  • Why log sequence number gets broken in SQL server

    Monday, June 29, 2015 11:18 AM

Answers

  • Hi Ranjit,

    As described in this blog, sometimes, the Log Sequence Number(LSN) of the log is broken due to some user actions. In this case, you cannot take the successive log backups until a full or differential backup is taken.

    The operations that will break the LSN chain are as follows:

    • Switching from the FULL or BULK_LOGGED recovery mode into the SIMPLE recovery mode
    • Reverting from a database snapshot
    • Taking Log Backup with NO_LOG option or with TRUNCATE_ONLY option.

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support




    Tuesday, June 30, 2015 6:29 AM

All replies

  • Sorry, but we need some more information. What about your server, version, and the errorlog from your ERROR?

    Why do you think, that your log sequence number get broken?

    Kind regards,

    Andreas


    Monday, June 29, 2015 1:04 PM
  • Why log sequence number gets broken in SQL server

    Log sequence number is not broken its chain which links various pages having LSN stamped on it this link is broken. Go search online you would find the answer.


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP


    Monday, June 29, 2015 1:27 PM
  • Hi Ranjit,

    As described in this blog, sometimes, the Log Sequence Number(LSN) of the log is broken due to some user actions. In this case, you cannot take the successive log backups until a full or differential backup is taken.

    The operations that will break the LSN chain are as follows:

    • Switching from the FULL or BULK_LOGGED recovery mode into the SIMPLE recovery mode
    • Reverting from a database snapshot
    • Taking Log Backup with NO_LOG option or with TRUNCATE_ONLY option.

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support




    Tuesday, June 30, 2015 6:29 AM
  • Thanks a ton Lydia 

    Wednesday, July 1, 2015 5:23 AM