Transaction Log | SQLWatchmen

Tag Archives: Transaction Log

DBCC loginfo, VLFs and SQL2000 and earlier.

by jmurphy on March 24, 2011 in SQL Server Maintenance, SQL Server Presentations

I was reading Paul Randall 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 [...]

Read full story • Comments Off

About SQLWatchmen

We are a Microsoft SQL Server database administration Managed Services and consulting company which specializes in helping smaller and medium sized companies protect and manage their data, as well as tune performance. SQLWatchmen has a staff of 6 employees for round-the-clock part-time monitoring.

If your company runs on SQL Server, but you are unsure if your data is really protected, or if your Disaster Recovery plan is not complete or is untested, then give us a call at (877) SQL-Watchmen and we will help you see where you stand.