How dulnindu123/database-backup-automation works
This is an enterprise SQL Server backup and disaster-recovery product. Operators configure backups through the desktop GUI or CLI; scheduled runs validate configuration, perform backup and encryption, and use the broker client to upload and report telemetry. Separate admin tools provision customer signing bundles, while recovery tools decrypt archives and run restore drills. The source excerpts and index establish the main client-side calls, but the README is empty and several listed subsystems were not sampled, so their internal connections are not asserted.
Main entry points: backup_core.py Backup engine · broker_client.py Broker client · preflight.py Preflight validation · app_gui.py Desktop GUI
Components 21
Backup operation
- Desktop GUI
app_gui.py - Command-line app
cli_app.py - Scheduled automation
auto_backup.py - Backup engine
backup_core.py - Version identity
version.py
Security and recovery
- Archive encryption
crypto_stream.py - Restore drill
admin_recovery_tool/admin_restore_drill.py - Recovery tools
admin_recovery_tool/decrypt_gui.py
Broker and agents
- Broker client
broker_client.py - Apps Script broker
apps_script_broker/Code.gs - Backup pull tool
apps_script_broker/pull_backup.py - Shell backup agent
shell_client/backup_agent.ps1
Customer administration
- Customer provisioning
Tools/setup_new_customer.py - Bundle signing
admin/sign_bundle.py - Batch provisioning
Tools/batch_setup_customers.py
Installation and validation
- Preflight validation
preflight.py - Setup wizard
installer_gui.py
Other components
- Operator
- SQL Server
- Local backup files
- Upload broker service
Connections 26
- Operator → Desktop GUI: configures
app_gui.py - Operator → Command-line app: runs
- Desktop GUI → Backup engine: uses
app_gui.py - Desktop GUI → Preflight validation: validates with
app_gui.py - Desktop GUI → Broker client: uses
app_gui.py - Command-line app → Backup engine: uses
cli_app.py - Command-line app → Preflight validation: validates with
cli_app.py - Command-line app → Broker client: uses
cli_app.py - Scheduled automation → Backup engine: runs
auto_backup.py - Scheduled automation → Preflight validation: validates with
auto_backup.py - Scheduled automation → Broker client: uses
auto_backup.py - Backup engine → Archive encryption: encrypts with
backup_core.py - Backup engine → Broker client: uses
backup_core.py - Backup engine → Version identity: reads
backup_core.py - Broker client → Upload broker service: uploads to
broker_client.py - Preflight validation → Broker client: probes via
preflight.py - Setup wizard → Preflight validation: validates with
installer_gui.py - Setup wizard → Broker client: uses
installer_gui.py - Setup wizard → Backup engine: uses
installer_gui.py - Customer provisioning → Bundle signing: builds signed bundle
Tools/setup_new_customer.py - Batch provisioning → Bundle signing: uses
Tools/batch_setup_customers.py - Restore drill → Archive encryption: decrypts with
admin_recovery_tool/admin_restore_drill.py - Restore drill → SQL Server: restores to
- Backup engine → SQL Server: backs up
- Backup engine → Local backup files: writes archives
- Apps Script broker → Upload broker service: provides endpoint