Category Archives: T-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 →

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 →

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 →