Database - Good practices

This section presents topics related to good practices regarding database administration and maintenance. Make sure to check each one of these items.

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

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

▪ When possible, try simulating the need to restore backups; this measure aims to identify possible failures in their media and routine.

▪ Periodically monitor the free space of the disk in which the database files are located; this way, it will be possible to prevent any type of failure due to lack of disk space.