SQL directory: specifying the SQL backup directory

Accessing SQL directory options
To access the SQL directory options shown above:

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.
4. Click SQL directory options to expand the section.

Setting the SQL directory options

Here you can specify the directory where SQL backup files (with .bak extension) will be stored before being transferred to the specified backup device. The database backup works by logging into your SQL Server and performing a database backup to file (with .bak extension). Each database backup is stored in a separate .bak file on disk. Database files are then transferred to your 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

1. Specify the drive and path for SQL backup files either by typing it directly into the Directory path field or by browsing for it.
   • You can also customize the SQL backup path by inserting unique variables:
     1. Click Insert variable.
     2. Choose a variable from the list.
     3. The variable will now be inserted into the SQL backup path enclosed with percentage signs (eg. %JOB_NAME%).
     4. You can insert as many additional variables as required.
     5. You can also order the variables as you like.
     6. An example backup path:
        • User input: C:\SQL_Temp\%JOB_NAME%\
        • Example path: C:\SQL_Temp\SQL Backup\