Recover the DS-System Database


Under extreme conditions, you might need to recover the DS-System database.

In such a scenario, please proceed according to the Knowledge Base Article "DS-System Database Installation Recommendations".

If restoring an older DS-System database dump is required, there are some potential problems:

1. New or modified Client/Customer information since the last backup will be lost.

2. Activity Log and Event Log since the last backup will be lost.

3. Reports since the last backup data will be lost.

4. Potential libraries info since last backup libraries is lost. Libraries might not get reused and new library creation will take longer for some library files.

5. Invalid Library links may in some extreme situations even prevent synchronization of backup sets and this means no backup/restore for that particular set until the links are manually fixed.

6. Used libraries may be marked as unused in the restore database. Clean Library Process will delete these files and restore of data will fail for those files. Error will not be detected during the next backup. This problem can be fixed by running a full System Admin.

7. New Library numbers will start with the last ID found in the database, potentially overwriting existing libraries and rendering restored data useless.

While the loss of information described above from 1-5 does not affect the online files, the last issue (7) would result in overwriting valid files with different new ones. Restoring files linked to such libraries will retrieve completely different files and will fail because of a different signature, encryption or compression.

In order to address this problem, whenever DS-System database is restored from an older dump, the information from database must be updated with the online before anything else. This process will add records into the database for all libraries created after the dump. This synchronization is triggered at the DS-System service startup by a negative value of DS_BUILD_NO field from ds_data table, dssystem database.

Whenever you restore a DS-System database dump, before starting DS-System service, please make sure that you run the latest installation in order to apply all latest database patches and make sure that DS_BUILD_NO field from ds_data table, dssystem database is negative. For example if DS_BUILD_NO has a value of 11, change it to -11.

It is recommended that you run a full System Admin as soon as the DS-System Service starts.



PREVNEXT