hai All user.... :)

I have the question concerning transaction log in database of baandb,where automatically grows the file is packed by percent i.e 10 percent n my question is anybody had replaced percent to In megabytes n what has impact that is produced if is changed to become 500 MB or another ???

regards
R 014 ND

roland,

from my experience, baan handles better by auto-growing in megabytes (eg 100 mb) rather than by %.

Thanks bernito 4 ur answer :)

I forget the file to ask about MAXIMUN's FILE SIZE What it I must choose if i changed In percent to In megabyte ??

regards
R 014 ND

Normally you wouldnt want to restrict the file growth, ie unrestricted, unless you have problems with db space.
If file growth (db and transaction log) is restricted, it will cause table locking once it reaches the max. On the other hand, you will have the same problem if the transaction log becomes too big and it reaches the limit of your db space.
You really need to watch out first how your db behaves before deciding on these things. The autogrow by megabytes could also be applied to the db itself, not just the log files.
The space allocated is also very important. I recommend at least 2 to 3 gb above your actual db size. again please note how your db grows.
Also run the SQL utilities to reduce the size of db and transaction logs.

Thanks benito... :)

I have some question again for u if i changed now from percent to megabyte in my server live there is a problem with my database ???...

regards
R 014 ND

I understand your concern. If you want, you can make a change at hours when you think there's minimal activity, eg offpeak hours.

I never had any problem making the change on my live environment anytime during the day.