Daily DS-System Database dump
The daily DS-System Database dump is performed for PostgreSQL and MS SQL databases. This is configurable using the "SkipDBDump" parameter in the DS-System Advanced Configurations screen - See "DS-System Advanced Configuration".
When DS-System starts (or at the configured time), a database dump is performed, provided that a dump does not already exist from the current date. The name of the dump file includes the date of the dump. By default, the dump is located in the first Extensible Storage location (e.g. \storage_location_1\dump). This location is configurable using the "DBDumpPath" advanced parameter.
- Note: The SQL service account must have rights (read / write) for this dump location (UNC path).
By default, DS-System keeps the last 2 dumps. When consolidating SQL dumps, the DS-System will compress the older one.
- By default, DS-System performs an hourly differential backup of the DS-System Database. If the dump for the current date does not exist, DS-System performs a full database dump.
- If the database is in "full recovery mode", DS-System also backs up (dumps) the transaction logs.
- DBCC is executed before the daily database dump. If DBCC fails, the dump will not be performed.
![]() ![]() |