You can translate the question and the replies:

Validating the Denodo Backups

Hi, We are taking denodo backup on daily basis. Will it be possible to vaidate the backup vql to make sure that we have a healthy backup. We want to carry this process on mothly basis. I don't find any way in admin guide to do same . for example: restore verifyonly in sql
user
19-07-2017 03:30:44 -0400

3 Answers

Hi, Whenever I want to validate my backup file I try to import it in a working Virtual DataPort Server. For example, I have a test virtual database created in my Virtual DataPort Admin tool to import the backup and check if it goes fine. To take the backup I use the Import/Export scripts available in the Denodo Platform Installation. By default when you execute the scripts on the command line by passing the parameters with necessary values it returns a status code "0" if no errors are found and it returns status code "1" if errors are encountered. This will help me to validate if it's a working backup. I would like you to refer to the official documentation on [Use of the Import/Export Scripts for Backup](https://community.denodo.com/docs/html/browse/6.0/scheduler/administration/appendix/use_of_the_importexport_scripts_for_backup) for more information. If you are a licensed user, you can also use the “Denodo Testing Tool” to check if everything works fine when you import the backup file. You can find more information about this tool in the document “Denodo Testing Tool - User Manual” which is available in the “doc” folder of the downloaded zip file that contains this tool. Hope this helps you!
Denodo Team
20-07-2017 08:09:18 -0400
Will it be possible to automate the export and import between two environments, if yes can you help us with the batch script to do so. I guess Exporting a vql in importing to other server will always give some error due to the license restriction or other privilage issue.
user
21-08-2017 11:04:12 -0400
Hi, To automate the export and import between the environments you can write a script to manage this with the necessary parameters. Also, you can export and import VQL between Virtual DataPort Servers when you are using Denodo Express. I want you to have a look at the following links on [Using the Import/Export Scripts for Backup And/or Replication](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/cluster_architectures_server_backup/using_the_import_export_scripts_for_backup_and_or_replication/using_the_import_export_scripts_for_backup_and_or_replication) and [Limitations of the Denodo Express License](https://community.denodo.com/docs/html/browse/6.0/platform/installation/appendix/limitations_of_the_denodo_express_license/limitations_of_the_denodo_express_license) Hope this helps!
Denodo Team
24-08-2017 03:38:11 -0400
You must sign in to add an answer. If you do not have an account, you can register here