Root Cause for Increasing the Transaction Log.

 Posted by Pandians on 7/20/2009 | Category: Sql Server Interview questions | Views: 2892
Answer:

1.Uncommitted Transactions.
2.Extremely Large Transactions.
3.Operations : DBCC DBREINDEX / CREATE INDEX.
4.Client Applications do not process all results.
5.While Restoring from Transaction Log Backups.
6.Queries Time-Out before a transaction log completes the expansion and you receive false 'Log Full' error message.


Asked In: In General | Alert Moderator 

Comments or Responses

Login to post response