Elephants can also drink up to 50 gallons of water a day about as much as a standard bathtub holds. Elephants are a keystone species that influence the composition of their environment while often benefiting other species.
Log Sequence Number. Every record in SQL Server transaction log has its own log sequence number or LSN. Log sequence numbers are ordered in such a way that changes related to the record with greater LSN occurred after the changes related to records with smaller LSN. Each backup that is set in SQL Server has FirstLSN and LastLSN values.
Determining the current log sequence number in a database. You can examine the current log sequence number (LSN) for a database to see how much room there is for growth in LSNs. In partitioned database environments, you must look at LSNs on each partition, as LSNs in different database partitions grow independently of one another. There are two ways to determine the current LSN for a given database.