SQL Backup Master Help

Online Documentation

Advanced temp folder config

The following advanced temp folder configuration options are available.

Important: These features are considered experimental.

Because these options use a customized (non-default) temp folder path, they opt out of the automatic NTFS permission hardening that v8.5 applies to the default local temp folder – you manage permissions on the share/folder yourself. See Backup Temp Folder Permissions for which configurations are SBM-managed versus customer-managed, and the SQL remote backups topic for the recommended setup (including the v8.5 Remote Setup script generator).

Alternate Temp Folder Mapping

This setting is designed for rare scenarios where you wish to present a different temp folder path to SQL Server (than the one SQL Backup Master sees) during backup operations.

For example, if you're running SQL Server on an Ubuntu Linux machine that's accessible to the SQL Backup Master host, you can use this option to facilitate remote backup operations. In this case, you would create a temporary folder (e.g. "/home/user/dbtemp") on the Ubuntu machine for housing database backups and share via samba. In SQL Backup Master, you would then specify the samba temporary folder share location using UNC path notation (e.g. "\\ubuntu\dbtemp"). Since the instance of SQL Server running on Ubuntu will not be able to access this UNC path, you can specify an alternate temp folder path (e.g. "/home/user/dbtemp") for use specifically by SQL Server.

When specifying an alternate temp folder path, keep in mind that it must resolve to the same location as your primary temp folder path.

For detailed Linux configuration guidance, see:

SQL Server on Linux with SQL Backup Master

Local Compression Staging

When enabled, backup files from remote SQL Server instances are compressed locally prior to being stored. This reduces network traffic, but requires local storage for each compressed database backup file.

Tip: Enable the "upload backups immediately" option in the Backup storage tab of your backup job settings to help limit the use of local disk space.

Network Authentication Credentials

If your temp folder path requires network authentication credentials, specify them here.