I wanted to know what are the different maintenance tasks that are run on the database servers on regular intervals. The ones I know are database backups, rebuilding indexes on timely manner. I am working on standards, to make them as routine processes.
Answer by DaniSQL ·
I suggest you add regular Integrity check(Daily or weekly depending on the size of your database) and Disk space monitoring to your maintenance schedule.
Edit: Also Make sure you come up with a plan to test your backups regularly.