Both a Weekly and a Daily Database Maintenance Plan should be created and scheduled to run accordingly.Initially the Weekly Database Maintenance Plan as outlined below should be run.
VersaDev recommends the following Daily Database Maintenance plan be created:
These recommended tasks should be added in the order below. VersaDev is not responsible for setting up Maintenance plans (unless negotiated otherwise)
1. Check database integrity
2. Check database size; in this step the business needs to consider defining an alert threshold to ensure that the database never reaches capacity and fails. As a recommendation the DBA should set a warning of at least 15% to ensure that the additional space is made available.
3. Reorganise Index
4. Update Statistics
5. Clean-up History
6. Backup Database
7. Maintenance Clean-up
VersaDev recommends the following Weekly Database Maintenance plan be created:
These recommended tasks should be added in the order below. VersaDev is not responsible for setting up Maintenance plans (unless negotiated otherwise)
1. Check database integrity.
2. Check database size; in this step the business needs to consider defining an alert threshold to ensure that the database never reaches capacity and fails. As a recommendation the DBA should set a warning of at least 15% to ensure that the additional space is made available.
3. Rebuild Index
4. Update Statistics
5. Clean-up History
6. Backup Database
7. Maintenance Clean-up