Log Sequence no

  • Hi gang

    i would like to know when the lsn no  changes in a sql 2000 database.I know it changes during log back ups but under what other circumstances will the lsn no change

    thanks in advance

     

     

  • SQL server marks each log record with Log Sequence Number.Every modification to database is logged, it can be anything like creating, committing, rollbacking transactions or backup, restore, or allocating pages or extents everything is logged.When a modification occurs, a log record is generated with a new LSN value. The same LSN value is stored (replaces the previous LSN value in the page header) in the data page header so the last log record and matching data page can be associated with each other. 

    For more information check Transaction log logical Architecture.  http://msdn2.microsoft.com/en-us/library/ms345419.aspx 

     

    Regards
    Shrikant Kulkarni

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

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