March 28, 2017

What is LSN chain in SQL

What is LSN chain in SQL

Every trasaction in sql server is identified by lsn number .means log sequence number

If LSN is broken then u may not able to restore it. Hope LSN needed in order to perform restoration.

LSN means log sequence number. Log file consists of internally log sequence number. If LSN is miss match we can't to restore data at point of time.

We can restore For e.g you have 1 full back and 4 log files, suppose if ur LSN broken on 3rd log file, then we can restore up to log file 2 rest all we can't restore it.