Database - Good practices

This section addresses the topics related to best practices regarding database management and maintenance. Make sure to verify each one of these items.

▪Check the possibility to create a routine to update the statistics and defragment the database objects.

▪Keep a database backup routine; the frequency must be set to meet the technical and business requirements.

▪Whenever possible, try to simulate the need of backup restoration; this action aims to identify possible failures in their media and routine.

▪Periodically monitor the free space in the disk where the database files are stored. With that, it will be possible to avoid any type of failure due to the lack of disk space.