Hi,

We are running BaaN IV c4 with Ms-SQL Server 7.0 as db on Win NT.
Currently approx. 20 users works concurrently.

Although I am not a SQL DB adminsitrator, but what I have seen is that per day db space consumption is about 50 mb which leads to approx. 1.5 gb / month usage at Database level.

I really doubt that this much transactions are entered in my system, ... my intution is that somewhere space is being used , may be some logs or may be something else at database level which I don't know... may be part of db administration activity, which needs to be cleaned up.

Am i thinking in right direction, if yes then what should I do.
Can i verify this ?? May be some chap running baan with Ms-SQL Server 7.0 as db can help me out.



Regards

Learner

the company I used to work for had exatly the same setup and my guess is that your logs are setup to only clear when they are backed up. check the truncate log setting on the database properties. set a limit on the file growth and set the truncate on checkpoint this is assuming you are not doing log backups.

My experience is with Oracle and not MSSQL but I think you may be surprised just how much space is consumed by database growth.

For example: Some tables such as tfgld410 for which, depending on your environment, many records are added for each baan transaction, have a large number of indexes which also consume disk space. (These records are ultimately posted to tfgld106 which again consumes space)

There are other tables that often have large numbers of records such as sls and pur order history tables, inv and ilc transaction history.

Terry