Skip to main content

Posts

Showing posts with the label sql tips and tricks learnig

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.