Transaction log keeps growing

Giganews Newsgroups
Subject: Transaction log keeps growing
Posted by:  yash…
Date: 24 Aug 2006


We have created a SQL server 2000 database. We observe that the
transaction log keeps growing over time. We are now about to run out of
space. We have been periodically shrinking the database. Nevertheless
the size has increased. I would imagine that a transaction log can be
eliminated if we stop the database. Can that be done? Is there a way to
completely wipe off the transaction log?