l2world_log.LDF file is Huge! Anyway to reduce?

[Calynx]

l2_world logs a lot of things, and its taking a lot of the hard disk space up. Is there anyway to reduce the logs or erase them after a certain amount of time?
Its already at
3.8 Million KBs
How do I reduce it?

[MentaL]

[Calynx]

Sorry for double posting, but I have also located an error log with

offset invalid count.

It just keeps on going and has already tallied up to 13 gigs....

[~Nyx~]

hehe, mine is 88gigs, you gotta shrink DB, right click it in EM... go to shrink DB, pick the l2world log, shrink it to minimum and restart your sql

[Calynx]

Thanks nyx for replying, and for helping me out alot.

I'm still at a problem with my server shutting off once in awhile, all the NPC freeze up and stop moving, and their corpse do not decay, Soulshots stop working, Item data is not being registered when you pick up items. I think a number of people had this problems before, but I wasn't able to find it as the search button was disabled. >.<

[learwood]

give u command :

backup log lin2world with NO_LOG
backup log lin2world with TRUNCATE_ONLY
DBCC SHRINKDATABASE(lin2world)

[Calynx]

thanks learwood