Kitview Database Backup V12

Technical Summary: Advanced Firebird Backup Solution

This utility is designed to automate the maintenance, security, and backup of Firebird databases in a Windows environment. It stands out for its ability to intelligently manage file locks (local and network) and verify data integrity before archiving.

🚀 Key Features

• Intelligent Proxy Management: The software automatically detects if the intermediate server (Proxy) is running as a Windows Service or as a Process (Application). It adapts its method to properly stop and restart it after the backup.

• Total Isolation (LAN & Local): It forces the closure of client applications on the server and orders the database engine to immediately disconnect all remote users (LAN), ensuring exclusive access to the file.

• "Deep Check" Validation: Unlike a simple copy, the program simulates an internal backup to verify the validity of every data page. If corruption is detected, the backup is cancelled to avoid overwriting healthy archives.

• Anti-Freeze System: Integrates timeouts to prevent the process from hanging indefinitely in case of a system error.

• Automated Alerts: In the event of a critical failure, a complete technical report (including logs and client identity) is sent via email to support.

---

⚙️ Workflow Process

1. Environment Preparation: The script obtains administrator rights, then forces the closure of user software (e.g., Kitview) to release local resources.

2. Proxy Server Shutdown: The program identifies the Proxy operating mode (Service or Executable) and stops it to cut off web/mobile access.

3. Database Locking (Offline Mode): A direct command is sent to the SQL engine to evict all active connections and prevent any new writing.

4. Verification and Archiving:

   • File integrity is tested in depth.

   • If the test is valid, the database is copied to the backup folder corresponding to the day of the week (7-day rotation).

5. Restoration: The database is switched back to "Online" mode and the Proxy (Service or Process) is automatically relaunched to restore user access.