• Excellent Article! and very well explained. still I have very simple question.

    I may be sounding asking a basic question but wanted to make some things clear here.

    what happens when the last lets say n'th VLF(VLFn) is full with the logs and logs between VLF3 to VLFn are all active and full with logs. where will be the next LSN generated? will it be in VLF1 and VLF2 if they are inactive/reusable state? if yes what will be the LSN for those new logs? highest/lowest?

    Thanks,

    Alpesh Pradhan