Big database (transaction log)

[Johan Saak]

Hi!

Just installed SIM and it works great.
But there must be something wrong with the SQL 2000 database. The transcation log grows very big. The Db file it self is only about 150 MB but the transactionlog is over 8 GB? I have tried transaction log backup, shrinking but nothing helps? Is there som kind of issue with the SQL code some where? Any one else has this problem?

Regards,
Johan

[andy steven]

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=423686

[Jadrice Toussaint]

Decrease the amount of memory used by SQL server. I saw significant changes after I change the memory used by SQL server from 1.5Gig to 250Megs.

[Mark Kempe]

After you do a backup of the log you need to run this SQL statement

DBCC SHRINKFILE(db_log, 100)

db_log being your transaction log and 100 being the size in MB you want to trim the log down to.