topic Re: Big database (transaction log) in Server Management - Systems Insight Manager

Big database (transaction log)

Johan Saak — Fri, 13 Feb 2004 03:07:34 GMT

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

Re: Big database (transaction log)

andy steven — Fri, 13 Feb 2004 09:59:23 GMT

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

Re: Big database (transaction log)

Jadrice Toussaint — Fri, 13 Feb 2004 10:01:54 GMT

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.

Re: Big database (transaction log)

Mark Kempe — Fri, 05 Mar 2004 11:58:55 GMT

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.