# Recommended DB Maintanance

**URL:** <https://www.epiusers.help/t/recommended-db-maintanance/44111>\
**Category:** Epicor ERP 10\
**Created:** [April 19, 2018, 4:47pm UTC](https://www.epiusers.help/t/recommended-db-maintanance/44111 "2018-04-19T16:47:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stewart\_McDonald](https://www.epiusers.help/user_avatar/www.epiusers.help/stewart_mcdonald/32/22416_2.png) [@Stewart\_McDonald](https://www.epiusers.help/u/Stewart_McDonald)\
**Post date:** [April 19, 2018, 4:47pm UTC](https://www.epiusers.help/t/recommended-db-maintanance/44111/1 "2018-04-19T16:47:29Z")

</div>

Hi,

Can someone point me to any documentation that outlines recommended database maintenance to be done on the EpicorLive10 DB per-emptivly?

The database size is increasing substantially and I do not want to get to a point that users are complaining about the system access time increasing and have an unhealthy database.

Any suggestions would be appreciated.

---

<div class="post-metadata">

**Author:** ![pwilliams](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/58f4c7/32.png) [@pwilliams](https://www.epiusers.help/u/pwilliams)\
**Post date:** [April 26, 2018, 12:14pm UTC](https://www.epiusers.help/t/recommended-db-maintanance/44111/2 "2018-04-26T12:14:36Z")

</div>

I assume that the database is in FULL not SIMPLE mode. If you backup the SQL log files regularly (depends on your business), you should be able to stabilize the growth. For our DB, we perform a full backup nightly and the logs are backed up hourly.

---

<div class="post-metadata">

**Author:** ![ERPSysAdmin](https://www.epiusers.help/user_avatar/www.epiusers.help/erpsysadmin/32/70700_2.png) [@ERPSysAdmin](https://www.epiusers.help/u/ERPSysAdmin)\
**Post date:** [April 26, 2018, 12:48pm UTC](https://www.epiusers.help/t/recommended-db-maintanance/44111/3 "2018-04-26T12:48:55Z")

</div>

Maybe you could look at some of these documents which can be found on EpicWeb:

Performance Diagnostic and Troubleshooting Guide (PDT)  
Performance Tuning Technical Reference  
SQLServerAdminGuide

Hmm, maybe I need to look at some of these myself… 🙂

I use Ola Hallengren scripts for my backups, index optimization and Database integrity checks, and to alert me of problems with these processes:

> **[SQL Server Backup, Integrity Check, Index and Statistics Maintenance](https://ola.hallengren.com/)**
>
> Award-Winning SQL Server Maintenance Solution for backup, integrity check, index and statistics maintenance in 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, and 2022

---

<div class="post-metadata">

**Author:** ![askulte](https://www.epiusers.help/user_avatar/www.epiusers.help/askulte/32/7325_2.png) [@askulte](https://www.epiusers.help/u/askulte)\
**Post date:** [April 26, 2018, 3:59pm UTC](https://www.epiusers.help/t/recommended-db-maintanance/44111/4 "2018-04-26T15:59:04Z")

</div>

What are your top 10 largest tables and sizes? Do you use Epicor’s Database Purge and Summarize Process?

---

<div class="post-metadata">

**Author:** ![mnewland](https://www.epiusers.help/user_avatar/www.epiusers.help/mnewland/32/5640_2.png) [@mnewland](https://www.epiusers.help/u/mnewland)\
**Post date:** [May 22, 2019, 3:44pm UTC](https://www.epiusers.help/t/recommended-db-maintanance/44111/5 "2019-05-22T15:44:51Z")

</div>

This is exactly what we do and it fixed our growth issues.