Administration > SQL Server Administration > Administration Tasks > Database Administration > Backing up a Database
  
Backing up a Database
You can create a backup by using one of the following tools:
Model Explorer
See Backing up a database (Model Explorer).
ScfUtils command line interface
See Backing up a database through ScfUtils.
Model Manager
SQL Server Management Studio
By default, Model Explorer, Model Explorer, ScfUtils, and Model Manger create backups using the SQL Server Full Backup mode. This mode takes a backup of the database at a given point in time, which allows full data recovery. You should take backups at regular intervals. To recover disk space, you can truncate logs after performing backups.
To achieve better performance for transaction-intensive workloads, use SSD drives.
For more information about Full Backups, refer to the following SQL Server help topic:
Create a Full Database Backup
https://docs.microsoft.com/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-2017#SSMSProcedure
* 
Backups should be performed on the machine that is hosting the SQL Server instance. The backup command in Model Explorer and Model Manager is disabled if the Integrity Modeler server is not local.
If you are using a remote machine to create a backup through ScfUtils, you should specify a UNC path for the backup file location. Local paths are relative to the Integrity Modeler server, and not the remote machine.
The backup process does not include the ModelerATFiles folder. If you need the ModelerATFiles data, you should copy the folder manually.