SQL Backup Master Help

The following advanced temp folder configuration options are available.

 

Important: These features are considered experimental.

 

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 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.

 

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.