SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

8/11/2009

How to recover from the Transaction Log (t-log) filling up

How to recover from the Transaction Log (t-log) filling up!!! This is the most frequently asked question in the forums or blogged. Hence, I thought let me write something on this so that this would be helpful to the DBA while they face this issue. What is Transaction Log (T-Log)? Why T-Log is full? Why my T-Log got filled up so fast? How do I get rid of T-Log filling up so quickly? What’s the issue all about? The problem here lies in the statement itself, that’s T-Log is getting filled up or is full!!!! To get better understanding...