In this section, we will provide a detailed description of all options available in the SQLBackupAndFTP backup job.
SQLBackupAndFTP performs a backup job in the following way:
- Creates a backup file in a temporary folder. If the temporary folder isn’t specified, SQLBackupAndFTP will use a default folder that is created when installing SQLBackupAndFTP, for example, C:\Users\admin\AppData\Local\Temp\Pranas.NET\SBF.
- Compresses the backup files in the temporary folder
- Removes the uncompressed backup file from the temporary folder
- Sends the compressed backup file to selected destinations
- Removes the compressed backup files from the temporary folder
Note: This process requires sufficient free space in the temporary folder to store both the backup file and the compressed backup file simultaneously.