Backup Repository Legacy Action

Importance of Backup

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

Workflow tab

1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
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

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
Version: 6.3.10.0

www.etl-tools.com

Performance

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