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 Uphttp://support.microsoft.com/?id=110139http://www.support.microsoft.com/?id=317375How to stop the transaction log of a SQL Server database from growing unexpectedlyhttp://support.microsoft.com/?kbid=873235and threads:http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/391579b8149281a4/b40ed8742075475d#b40ed8742075475d?sa=X&am...
