How to configure Microsoft SQL database backup

How to configure Microsoft SQL database backup

In this article, you will get information on how to configure the Microsoft SQL database environment using Xopero ONE.

The database backup process in Xopero ONE can be split into two different operations:
  1. Creating a database dump using backup scripts,
  2. Performing a backup of the database dump.
The first operation is triggered through Xopero ONE using the Backup scripts feature, and the second action is simply a file-level/image-level backup plan performance done directly by Xopero ONE.
This article describes how to use Backup scripts in order to create a Microsoft SQL database dump, so it can be included in a backup plan.

See also how to create a file-level backup and image-level backup plan using Xopero ONE

How to backup Microsoft SQL environment using Xopero ONE

To configure the backup Microsoft SQL database environment open Plans tab and Add plan, then select Advanced settings tab on the bottom.

advanced settings

Scroll down to the Backup scripts and click the pre-backup script.
Enabling pre-backup script

Toggle the pre-backup script switch to ON and select the script dedicated for backup Microsoft SQL database environment.

Choosing the database type

Enter the SQL username in the "Database user" field.

It is good practice to create dedicated users responsible to perform database backup tasks.

Setting the database username

Set the user password by adding it to the safe password manager or setting it from the list.

The user provided for Database user field must use SQL Server authentication
Choosing or setting the password

With the next step it is required to set up the script arguments.

Setting script's arguments

Script arguments should be provided into Script arguments field this way:
copy_type server_name output_dir [database1] [database2] ... [databaseN]

where:
  1. copy_type - parameter responsible for setting what copy type should be performed. The user can decide which of 3 copy types should be used: full_only, full_diff, and copy_only.
    If full_only selected always performed will be the full copy.
    If full_diff is selected performed will be a differential copy with a periodic full copy.
    Copy_only type should be set only if at the same time other backup software is performing a backup task.


    Full copies are performed according to the planned schedule. Differential copies are performing always when differential and incremental copies are planned on schedule.

    If the file contained a differential copy will be deleted, and the next differential copy will be created respecting to last full copy made.
  2. server_name - Microsoft SQL server name along with an instance.
  3. output_dir - the directory where the database dumps will be placed, and which should also be selected as directory to backup.
  4. [database1] ... - names of databases (everything should be separated by a space) to be backed up. However, you can ignore this option - if no database is selected, Xopero ONE will automatically protect all databases from the server the user indicated in the database access parameters.

Set two additional options by using the checkboxes - Wait for the script to continue the task, so the application will wait until the dump is ready and Fail the task if the scripts fails  - so in case of script failure, the system will also notify about backup error.

Setting 'Fail the task if the script fails' checkbox

After setting "Save" configuring backup for the Microsoft SQL environment will be finished.
See also how to create a file-level backup and image-level backup plan using Xopero ONE


    • Related Articles

    • How to configure PostgreSQL database backup

      In this article, you will learn how to configure the PostgreSQL database environment using Xopero ONE. In general,  a disk-level backup should protect the whole database instance, when VSS settings option is enabled. However, to ensure that data ...
    • How to configure MySQL database backup

      Overview The database backup process in Xopero ONE can be split into two different operations: Creating a database dump using backup scripts, Performing a backup of the database dump. The first operation is triggered through Xopero ONE using the ...
    • Backup scripts

      In this article, you will find information about backup scripts. Types There are three types of backup scripts: Pre-backup - the script is executed before the backup starts. There is an extra option to wait with backup start until the script is ...
    • Xopero ONE Microsoft 365 backup overview & supported apps

      This article contains information about Microsoft 365 backup and supported apps Xopero ONE Microsoft 365 backup overview & supported apps Overview To run any task in Xopero ONE firstly you have to configure a plan - backup plan, replication plan, ...
    • Microsoft 365 dashboard

      Viewing the Microsoft 365 dashboard The Microsoft 365 section allows viewing the statistics of the Microsoft 365 backup statuses. Each user has its own dashboard. To reach the dashboard open the Microsoft 365 tab. Click Manage & Restore button on the ...