Developer forum

Forum » Development » Trim database size?

Trim database size?


Reply
Hi,

Once in a while we create a backup of our production-database and use this database on our development-machines.

This works fine, but the problem is, that the backup-file just grows and grows in size.

It must be possible to remove som of the data in order to keep the database on the developer-machines smaller.

My question is: Which tables can be cleared?

My candidates are (based on their current size):
1. Every table starting with StatV2
2. TrashBin
3. VersionData
4. ActionLog

Is it ok to clear these tables or will I run into problems during development?

Regards,
René

Replies

 
Nicolai Høeg Pedersen
Reply
You an without any issues empty those tables.
 
Reply
You can sometimes acheive a lot by clearing the log file, table statistics, indexes and shrinking the database.

BR.
Lars

 

You must be logged in to post in the forum