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.
The log in this backup set terminates at LSN 231323000015712500001, which is too early to apply to the database. A more recent log backup that includes LSN 239029000000366300001 can be restored. What I need is to do is to get the current LSN number of the current database. RESTORE HEADERONLY FROM DISK = 'D:\db.BAK'.