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:
- 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 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.
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.
Scroll down to the Backup scripts and click the pre-backup script.
Toggle the pre-backup script switch to ON and select the script dedicated for backup Microsoft SQL database environment.
Enter the SQL username in the "Database user" field.
It is good practice to create dedicated users responsible to perform database backup tasks.
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
With the next step it is required to set up the script arguments.
Script arguments should be provided into Script arguments field this way:
copy_type server_name output_dir [database1] [database2] ... [databaseN]
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.
server_name - Microsoft SQL server name along with an instance.
output_dir - the directory where the database dumps will be placed, and which should also be selected as directory to backup.
[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.
After setting "Save" configuring backup for the Microsoft SQL environment will be finished.
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 ...
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 ...