I’m Sorry, I Can’t Let You Expand That Log File, Dave!

Thanks to all the wonderful people who attended my recent presentation on Transaction Log File Management at the Winnipeg SQL Server User Group Meeting! I had a lot of fun, and hope you found the presentation both enjoyable and informative.

I’m Sorry, I can’t let you Expand that Log File, Dave!

As promised, I’m making the presentation available for download here.

The scripts mentioned in the presentation are:

  1. Detect databases with a high VLF count
  2. Fix databases with a high VLF count

Read the rest of our series on Database Recovery, and please let me know what you thought of the presentation in the comments below!