Configuring SQL database directory destination options

 

The database backup works by logging into your SQL Server and performing a database backup to file (with .bak extension). This database backup file is then transferred to your backup device (tape, hard drive, network server, etc.) This design gives you maximum flexibility when you need to do a restoration, because your SQL Server does not need access to your tape drive (or other backup device).

SQL Method jobs are designed only to write database backup files to disk. If you need to transfer database backup files to a different hardware device (tape, REV, etc), you would need to create an additional NTBackup Method job.
Creating additional backup jobs

To access the destination settings for the SQL backup directory:

  1. Click Jobs in the navigation bar
  2. Select the job to be edited and click Edit at the bottom of the window.
  3. Click Destination on the left menu.

SQL directory options
Specify the drive and folder where the database backups (.bak files) should be stored (and any variables you wish to use).

Backup storage options
Determine how to manage disk space on your SQL backup directory and how many backups should be kept in archive. These settings are used to ensure that there is enough room on your SQL backup drive to store new backup files. For example, if you have limited storage capacity on the drive, you would need to continuously clear the disk manually of backup files to accommodate new ones. It is much easier to let BackupAssist manage disk space and there are a number of different options available.