Prevent 3GB+ transaction log

[Liselotte]

Hi all, well, last time, i run my server and every 4 days, my transaction log or database log reach 1GB everyday, and on the 4th day, the log wont accept the data anymore. which means, players wont be able to save their account, and character info while playing the game. So i have to wipe out the database. But with this guide, your log will reach 2mbs a day. no more database log FULL. or 3GB+ Logs to your database.

Ok heres the guide for empty database:
1:Open Enterprise Manager
2:Go to your MuOnline database
3:make a right click and select properties
4:now, go to Option tab panel
5:you will see:
Recovery

Model:
Full
change it to simple
6:On settings, check Auto Shrink
7: and press ok

now, your log will get 2mbs each day

For non-emplty database:
Use this program and it will shrink your database
Here

 

[archmage3]

nice guide

 

[AemageddoN]

Thx for guide

 

[email]

Re: [Guide] Prevent 3GB+ transaction log

Perfect Work

 

[djspankman]

Re: [Guide] Prevent 3GB+ transaction log

Great that you are sharing, but isn't a guide like this already posted Liselotte?, or was it something similar to it? I think I saw something about making them smaller somewhere . Not saying it's bad guide: it's great that you share .)
Once again good that you share since most are lazy to search .