---
title: "Backup - Restore"
canonical: "https://wiki.soft1.eu/space/SS5EN/189268579/Backup%20-%20Restore"
format: markdown
---
Backup and restore procedures should be considered as essential procedures for data protection and security. The process of creating and keeping copies of data protects your database against data loss and is required not only to avoid unpleasant surprises but also for the smooth operation of the installation. Creating copies of data should be performed on a daily basis (night hours) after midnight and before any system's update to the latest release/version or the creation of custom designs.
See below the process to backup and restore your copies of data by using the specific jobs developed by SOFT1.
---
---
---
##### → zbackup from command line
| **Data export (Backup)** | **Data import (Restore)** |
| --- | --- |
| > ❌ *Before proceeding to the data export process, you should have previously ensured that no transactions are performed at the SQL database, where the data will be exported from.*
**Command for data export **(On premises installations)
*zbackup out -s -d -u -p -f.zbcp*
- SERVER : SQL Server Name
- DBUSER, PASSWORD: Username and password to use for the connection with the SQL Server.
- BACKUP_FILE: the name under which the file should be saved.
:info: *Each time the data export process is completed, the . zbcp file file is automatically created at the same directory with the zbackup.exe* | > ❌ *Before proceeding to the data import process, you should have previously ensured that:*
> ❌
> ❌ 1. *the database already exists at your server because it is not automatically created when Import is running using the zbackup tool.*
> ❌ 2. *whatever exists at the database before running the import process, will be deleted!*
> ❌ 3. *the. zbcp file and the zbackup.exe should at the same directory.*
**Command for data import **(On premises installations)
*zbackup in -s -d -u -p -f .zbcp* |
| **Command for data export** (Azure/Cloud installations)
* zbackup out azure -f .zbcp* | **Command for data import **(Azure/Cloud installations)
*zbackup in azure -f .zbcp* |