Category Archives: T-Log

Shrinking Transaction log


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


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 | 8 Comments

Reason for Large Transaction-Log File


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