Tag Archives: Transaction Log

DBCC loginfo, VLFs and SQL2000 and earlier.

I was reading Paul Randal and Kimberly Tripp’s discussions about Virtual Log Files (VLFs), found here. DBCC loginfo I found that performing a log backup will cause the active VLF to ‘rotate’ to the first VLF, freeing up the rest of the VLFs for maximum shrinkage. Uh, well, you know what I mean. In SQL […]