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: Database Corruption Part 5 :: Dealing with Log File Corruption

    Hi Friends, I am back again after a long time. Last month was the end of yet another financial year, and all of us were very busy with the processes involved with each year-end. Now that all those are completed, I could find some time for my next blog post on database corruption. Here, I will be targeting...
  • Blog Post: Database Corruption Part 4 :: Recovering from a failed disk

    It was a nice day a few days back - nice sunny day, with moderate temperatures. I got up early and after spending some time reading my favorite articles, made my way to office. In office, I realized I hadn't much work lying ahead; so sat down wondering how to account for my day. Suddenly the phone on...
  • Blog Post: Database Corruption Part 1 :: Introduction to Database Corruption in SQL Server

    Hello Everybody, I think you will all agree with me that database corruption is one of the nightmares in the life of a DBA. We store precious data in databases and each day the dataset grows bigger and bigger. A database corruption issue not only puts the data at risk, it also threatens to take a toll...
  • 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 (5 items)