# Database Size

**URL:** <https://www.dynamicsuser.net/t/database-size/12095>\
**Category:** Technical Forum\
**Created:** [July 3, 2003, 8:41am UTC](https://www.dynamicsuser.net/t/database-size/12095 "2003-07-03T08:41:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilikeyou75](https://avatars.discourse-cdn.com/v4/letter/i/71c47a/32.png) [@ilikeyou75](https://www.dynamicsuser.net/u/ilikeyou75)\
**Post date:** [July 3, 2003, 8:41am UTC](https://www.dynamicsuser.net/t/database-size/12095/1 "2003-07-03T08:41:13Z")

</div>

Hi, I have one database. I haven’t run the Inventory Periodic Activities for last 6 months. If i run the periodic activites the database size is getting by 5 times, frm 300MB to 1.4GB. What coud be the reason.? If you actually see the database info, it is using only 30% of the size and rest is free. can I able to reduce the size by any…? help me. Bye Ram

---

<div class="post-metadata">

**Author:** ![anfinnur](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@anfinnur](https://www.dynamicsuser.net/u/anfinnur)\
**Post date:** [July 3, 2003, 9:16am UTC](https://www.dynamicsuser.net/t/database-size/12095/2 "2003-07-03T09:16:54Z")

</div>

The version-control (roll-back) demands space, that is for sure. And running that periodic activity first time after such a long period demands relative much space. You cannot reduce the database-file (native); only way is to make a [Tools]backup of everything, create a new database with a “suitable” size and then restore. But then again - the import itself also demands database-space… Advice: Run “Inventory Periodic…” at least once a week! Not only because of the db-size, but also because of your [customers] company!

---

<div class="post-metadata">

**Author:** ![David\_Singleton](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/david_singleton/32/7471_2.png) [@David\_Singleton](https://www.dynamicsuser.net/u/David_Singleton)\
**Post date:** [July 3, 2003, 4:14pm UTC](https://www.dynamicsuser.net/t/database-size/12095/3 "2003-07-03T16:14:47Z")

</div>

In any case you should expand the database out to 2 Gb.
