Hi,
i would suggest to refer below KBs and threads ,for cause of Transaction Log becoming full and how to reduce Locks and how to stop it :
Causes of SQL Transaction Log Filling Up
http://support.microsoft.com/?id=110139
http://www.support.microsoft.com/?id=317375
How to stop the transaction log of a SQL Server database from growing unexpectedly
http://support.microsoft.com/?kbid=873235
and threads:
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/391579b8149281a4/b40ed8742075475d#b40ed8742075475d?sa=X&oi=groupsr&start=1&num=3
http://groups.google.com/group/comp.databases.sybase/browse_thread/thread/4ad5e6818968385c/fac9ed81dd813cd9#fac9ed81dd813cd9?sa=X&oi=groupsr&start=0&num=3
http://www.dbazine.com/sql/sql-articles/mullins-sqlserver
HTH
Regards
3/07/2006
Cause for T-Log become Full and how to reduse it
10:46 AM
filling up, growth of t-log, microsoft, sql server, t-log, transaction log, unexpected
No comments
0 comments:
Post a Comment
I appreciate your time, thanks for posting your comment. I will review and reply to your comment as soon as I can.
Thank you
Hemantgiri