SQL Server for Beginners - How Does the Transaction Log Work?!?

‪@SQLBalls‬ Discusses how the SQL Server Transaction Log works. How VLF's Work and he gives an example of finding transaction log space, understanding that only a log backup will flip status bits in VLF's with no active transactions, a piecemeal restore, and more!

GitHub Repository for the demo scripts:
https://github.com/sqlballs/SQLScript...

Here's some additional documentation:
The Transaction Log (SQL Server)
https://learn.microsoft.com/en-us/sql...

/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field
Twitter:   / talesftfield  
Linkedin:   / 100091910  
Blusky: https://bsky.app/profile/talesfromthe...

Bradley Ball
Twitter:   / sqlballs  
Linkedin:   / sqlballs  
Blusky : https://bsky.app/profile/sqlballs.bsk...


Daniel Taylor
Twitter:   / dbabulldog  
Linkedin:   / danieltaylor3  
Blusky: https://bsky.app/profile/dbabulldog.b...

Neeraj Jhaveri
Twitter:   / neeraj_jhaveri  
Linkedin:   / neerajjhaveri  
Blusky: https://bsky.app/profile/neerajny.bsk...

Josh Luedeman
Twitter:   / joshluedeman  
Linkedin:   / joshluedeman  
Blusky: https://bsky.app/profile/joshluedeman...

Andrés Padilla
Twitter:   / nodestreamio  
Linkedin:   / andrespadillaandrade