Compatibility List

SQL Server compatibility list

Restrictive explanation

• To ensure the correctness of backup data, other backup software or scripts need to be closed before backup.
• Backup and restore SQL Server databases on a database-by-database basis.
• Backup and recovery must be performed using a user with sysadmin privileges.
• A database overwrite recovery can only be performed if a database with the same name, instance name, and data file path as the source database exists on the target host.
• The source database's recovery mode should ideally be set to "Full," as it provides the most recoverable configuration.
• If the source database mode is "Simple," log backups are not supported.
• If the source database mode is "Bulk Logged," log backups do not support restoring the database at a specified time.
• Before restoring the master database, the target database needs to be manually started in single-user mode.
• Databases with a simple recovery mode should have a separate backup task created and should not be mixed with databases of other recovery types in a single backup task.

Preparation before backup

Check the Backup Services Log On Account

If you want to use Windows Authentication mode to configure the database for backing up, please edit the database backup services to log on as administrator from Windows Services. Please first stop the "database_backup_service" and "database_transfer_service" services by right click on them and select Stop.

When these 2 services have been stopped, right-click on them and select Properties > Log On, select log on as this account, then fill in the administrator account name and password, click on Apply and restart the backup services.

Check Database User Permission

If select SQL Server Authentication mode to configure application. Please check the database user permissions for which you wish to perform SQL Server database backup, at least ensure the user has sysadmin permission, check the details below.

Check Recovery Model

Check the recovery model of database, please ensure the recovery mode is "Full", otherwise log backup job will fail.

Prerequisites for creating a backup job

• The backup database version is within the compatibility list, and the corresponding version client is installed. Perform application configuration in [Agent & Client].
• In the backup system [Agent & Client], confirm that the host status is online.

Preparation before restore

Recovery target

• Create New Database: Restore the database to another host.

Recovery mode

Create New Database

Suitable for verifying backup data and restoring to a different machine. After selecting new database recovery, you must configure a new database name, database file path, and log file path.

During batch recovery: 1. Overwriting recovery is not permitted for databases with identical names. 2. When recovering a newly created database, duplicate database names are not allowed.

Prerequisites for restore

• To restore to a different machine, the corresponding client version must be installed on the target host and the application configured.
• When performing the restore task, the operating system user with the backup client installed should have read, write, and execute permissions for the target directory.
• Backup and restore must be performed using a user with sysadmin privileges.

Select Restore mode

Creating a new database for recovery is suitable for verifying backup data and restoring to a different machine. After selecting this option, you need to set a new database name, database file path, and log file path. Unless you have specific needs, creating a new database for recovery is recommended.

Clicking the folder on the right allows you to select the target path in the tree-like directory structure. You can also add custom folders. Clicking the first icon to the right of the system-created recovery folder allows you to create a subfolder; the second icon allows you to edit and rename the folder; and the third icon allows you to delete the folder. Clicking the search button next to the directory allows you to search for folders within that path.