How the Initial VLF sequence number gets decided of the default transaction log file

Geschrieben von Database Magician am Freitag, 30. Juni 2017

'In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed the undocumented command DBCC LOGINFO, one of the common questions which I got – ‘How the Initial VLF sequence number gets decided of the default transaction log file’? In this tip, I will show you how the first VLF sequence numbers get chosen.'...

http://www.sqlservercentral.com/blogs/sql-geek/2017/06/20/how-the-initial-vlf-sequence-number-gets-decided-of-the-default-transaction-log-file/