Blogs from Suhas

Dirtying my hands in SQL Server

Browse by Tags

Tagged Content List
  • Blog Post: Transaction Log Backup Size in Bulk Logged Recovery Model

    Assume that I have a database in Bulk Logged Recovery Model, and I perform a bulk operation that is minimally logged. Now, if I take a Log Backup, should not my Log Backup File Size be smaller than if I had performed the same operation in Full Recovery Model? I have seen many people confused by this...
  • Blog Post: Revealing the secrets - Truncating a Transaction Log File

    In my earlier blog post on Shrinking the Transaction Log files in SQL Server , I had mentioned that a VLF can be truncated only when all transactions, that have at least one command written into the specified VLF have either been committed or rolled back. While this is true, I understand that it might...
  • Blog Post: Shrinking the Transaction Log files in SQL Server

    Hi Friends! This blog post is mainly to address concerns about increasing log file space, and how to go about to shrink the file. I am adding a priliminary content here as of now, but I will update this content as and when I get time and new content to add. Question: What is a log file, and why...
Page 1 of 1 (3 items)