We have recently shared updated Server Recommended Specifications and provided reminders regarding the End of Life for certain Operating Systems and SQL software from Microsoft. These reminders are a part of our ongoing commitment to ensure the smooth operation of your systems.

As we continue with this initiative, we would like to emphasize the importance of your IT team's role in setting up and configuring standard maintenance services correctly. These practices are fundamental for your IT team to ensure that your system meets the basic requirements for proper maintenance and to prevent critical issues in the event of technical challenges. These issues may include downtime due to hardware-related downtime to data corruption and security vulnerabilities, including threats like viruses and ransomware.

Your IT team's attention to these protocols is vital for the continued reliability and security of the systems but also to proactively address potential challenges and maintain the overall integrity and security of your systems. We appreciate your cooperation in implementing these measures to safeguard your systems effectively.

The following are essential maintenance plans that should be executed and deployed on a daily and/or regular basis:

1. Full Automatic / Manual Backup: This includes creating comprehensive backups of the latest Bizbox Database and Reports, and ensuring that OFFSITE backups are also maintained. These backups are crucial for data security and recovery in case of unforeseen issues. To get guidance on setting up automatic and manual backups, please visit the KBA link provided. Additionally, you can refer to the accompanying image for standard backup recommendations to ensure a proper backup setup.

https://helpdesk.bizbox.ph/portal/en/kb/articles/1-automatic-database-back-up-maintenance-plan-1

2. Optimize Re-Index Script: This process involves optimizing the indexing of your database. By regularly executing this script, you ensure that the database continues to perform efficiently, enhancing overall system responsiveness. To get guidance on setting up a DB re-index script, please visit the KBA link provided.

https://helpdesk.bizbox.ph/portal/en/kb/articles/database-reindex

3. Database Shrink: The Database Shrink process helps in managing the database size by reclaiming unused space. This regular maintenance task helps prevent unnecessary storage bloat and keeps the database running smoothly. To get guidance on setting up the shrink database, please visit the KBA link provided.

https://helpdesk.bizbox.ph/portal/en/kb/articles/sql-database-shrink

These maintenance plans play a vital role in the overall health and performance of your system, ensuring data security, efficient operations, and optimal resource utilization.

If you have any questions or need further assistance with these maintenance plans, please don't hesitate to reach out. Your proactive approach to system maintenance is greatly appreciated.