Performing a daily DS-System database dump
When DS-System starts (or at the configured time), a database dump is automatically 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 primary storage location (for example:
\storage_location_1\dump). This location is configurable using the
DBDumpPath advanced parameter. For more information on the database dump parameters, see
“Configuring the advanced settings”.
NOTE: The SQL service account must have read/write permission for the dump location (UNC path).
By default, DS-System keeps the last two dumps. When consolidating SQL dumps, the DS-System will compress the older one. For Microsoft SQL Server databases:
• 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.