Performing a daily DS-System database dump
When the DS-System starts, a database dump is automatically performed, provided a dump does not already exist from the current date. By default, the dump is located in the primary storage location, which you can configure using the
DBDumpPath advanced configuration parameter. For more information, see
“Configuring the advanced settings”.
By default, the DS-System retains the last two database dumps. When consolidating SQL database dumps, the DS-System compresses the older database dump.
For Microsoft SQL Server databases, consider the following:
• The DS-System performs an hourly differential backup of the database. If the database dump for the current date does not exist, the DS-System performs a full database dump.
• If the database is in full recovery mode, the DS-System performs a backup of the transaction logs.
• DBCC is executed before the daily database dump. If DBCC fails, the database dump will not be performed.
IMPORTANT: The SQL service account must have read/write permission for the dump location (UNC path).