April 26, 2007 at 8:34 am
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
April 27, 2007 at 5:57 am
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