target section in the restore job settings file, the data for a database connection is specified.
The fields that should be filled in, in the
target section, depend on the type of database to which the connection should be set. The
type is specified in the type field. Currently, only Microsoft SQL Server can be specified as a data sink.
The type of object to which a restore should be made.
mssql– Microsoft SQL Server.
mysql– MySQL Server.
New DBMS types will be added in the future.
This parameter is for closing existing connections to the database before restore. Defaults to
List of database names whose backups need to be found in the repository and restored.
The name of the source object (database) that is stored in the storage.
A new name for a restored object (database). If the object already exists, it will be overwritten.
File Overrides for SQL Server
For SQL Server, the paths for the database files can be overridden. The new paths for the database files are specified in the
files field. This is useful if you want to restore a database under a different name on the same server as the original database. It will not be possible to restore a backup without specifying new paths to the database files, since the paths to the database files are recorded in the backup and are already used for the original database.
Settings for a local SQL Server connection to backup two databases: DataOne and MediaOne:
Database restore under a different name with new paths for data files:
More examples in the Samples section.