Backup Repository Action

Importance of Backup

Regular backup is a necessary action to protect the business from data loss.

Workflow tab

Backup Repository Action

  1. Write Variables option forces package action to save variables values into the log file before the execution.
  2. It is usually used for debugging and not recommended for production environment.
  3. It can be globally disabled using options dialogue

After execution tab

Specifies which variables will be set once action execution is completed

Backup Repository Variables

About backup

Backup is a zip file which has sqlite database inside and ReadMe.txt file with a metadata about backup.

ReadMe.txt Example

Repository Backup
Repository Name: SQL_SERVER
Repository Type: MS Sql Server
Repository Server: DBSLAMD\SQLEXPRESS2019
Repository Database: AETL_REPOSITORY
Created: 05/04/2023 09:47:12
Computer Name: DBSLAMD
User Name: dbsl
Application: AdvancedETLEnt.exe


For very large repository it might take a while to perform backup. In this case we recommend clearing QUEU\* tables

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: November 29, 2023