Datagate Maintenance is an automated maintenance module that runs essential database maintenance operations without manual intervention. All operations send email notifications — both success and failure — with detailed logs attached (generated by SQL Server or the command line).

Database Backup

Automatically back up all databases in the configured list. Before you begin, check the available free disk space — if there is not enough space, the operation is stopped and an alert is sent.

Shrink & Optimize

Two complementary operations that maintain database performance over time:

Reindexing and recalculating statistics — processes only indexes and statistics that actually need recalculation, not the entire database. It uses the AzureSQLMaintenance algorithm, optimized to minimize the impact on ongoing operations.

Database Shrink — recovers unused space from database files. It runs progressively, in small steps, without blocking users' access. If launched from the command line (not the interface), the shrink runs only on Sundays, avoiding interference with working hours.

Archiving Backups

Automatically manage the lifecycle of backup files:

• Monitors available space on the backup disk and sends alert when it drops below 10%
• Delete backups older than the maximum number of days configured
• Always keep a monthly backup — the one on the 1st of each month — regardless of the deletion policy, providing a long-term restore point