Create a SQL backup job

NAVIGATION  Jobs > Active Jobs > Create Job > Backup

PERMISSIONS  Administrator

Create a SQL backup job to protect SQL Server databases, clustered instances, and availability groups.
This procedure assumes that you have added to the appliance each SQL asset you wish to protect.

BEFORE YOU BEGIN  Review Backup jobs and ensure you have added all SQL assets to the Unitrends appliance.
For clustered SQL environments, see Protecting SQL clusters and availability groups for instructions on adding cluster and availability group assets.

How SQL assets appear in the inventory tree

Because clustered instances and availability groups can move between server nodes, they must be added as separate assets.
In the Create Backup Job dialog, each SQL instance or availability group displays under its host asset:

  • For SQL server assets, hosted non-clustered instances display.
  • For SQL cluster assets, the clustered database instance displays.
  • For availability group assets, the availability group displays.
  • Expand the asset to view and select hosted instances, availability groups, or databases.
  • To check the SQL asset type, hover over the asset. SQL Cluster displays for clustered instance assets; SQL Availability Group displays for availability group assets.

SQL Assets In create Job

Create a SQL backup job

NOTE  If you recently added assets to your environment, sync inventory before creating your job: click the Gear icon in the upper-right of the UI and select Inventory Sync.
Options Icon

To create a SQL backup job, complete the following steps:

  1. Select Jobs > Active Jobs > Create Job > Backup.

    Agent Backup 1

  2. Select SQL in the What do you want to backup? list.
  3. In the Inventory tree, expand the SQL host and check boxes to select databases to protect.
    Selected databases display in the Job Inventory Settings area.
    • To locate an asset by name, use the Search field below.
    • To view individual databases, expand the SQL host and any instances and availability groups.
    • To quickly select multiple databases, click an instance or availability group checkbox.
    • To select one database, click its checkbox.
  4. (Optional) Repeat step 3 to include databases on other host assets.
    SQL Backup 1
  5. (Optional) Check the Auto-include new databases box to automatically add newly discovered databases to the schedule.
  6. Click Next.

  7. Select Now or Create a Schedule to specify when you want this job to run.
    If you create a schedule, enter a unique job name.

  8. Set remaining Job Details and Options.

    In most cases, the standard backup modes can be used to create the schedule.
    If you need more granularity, choose Custom to create a custom backup calendar.
    See Configure a custom backup schedule for details.

  9. Click Save.
    SQL Backup 2

  10. Click OK to close the Success message.

    schedule success

    • If you created a schedule, the job runs at the date and times you specified.
    • If you chose Now, the job queues immediately.
      Click Active Jobs to view the running job.

The SQL backup job is created.
Unitrends protects the selected databases according to the schedule you configured.