Category Archives: T-Log

Shrinking Transaction log

Posted on February 6, 2012 by

Some days back, I had a discussion with one of my colleague about Shrinking a database log file. He told me that they had a database with a log size 10 times larger than the data file size, and they … Continue reading →

Posted in Backup - Restore, SQL Server, T-Log | Tagged , | 2 Comments

Tail-log Backup without the Primary Data File

Posted on April 15, 2011 by

While I was reading a post, written by Vinod Kumar (blog | twitter) about Files and FileGroups with SQL Server, I found an interesting quiz question: “Do we need the primary data file available to backup your transaction log after a crash?“ … Continue reading →

Posted in Backup - Restore, SQL Server, T-Log | 6 Comments

Reason for Large Transaction-Log File

Posted on January 4, 2011 by

Well, this is the most frequent question we found in the MSDN forum. I had asked the same question couple of years back, and understand the need to Transaction Log with the help of the SQL Server Community. However, I … Continue reading →

Posted in SQL Server, T-Log | Leave a comment