Restore Options

Bacula Enterprise Only

This solution is only available for Bacula Enterprise. For subscription inquiries, please reach out to sales@baculasystems.com.

It is possible to restore the data with different scenarios using the following options:

The common restore “Where” parameter (where=<path>)
The common restore “Replace” parameter (replace=<never|always>)
The Plugin restore option accessible in the “Plugin Options” menu at the restore prompt (Item 13).

Run Restore job
JobName:         RestoreFiles
Bootstrap:       /tmp/regress/working/127.0.0.1-dir.restore.9.bsr
Where:           c:/tmp
Replace:         Never
Fileset:         Full Set
Backup Client:   win2008-fd
Restore Client:  win2008-fd
Storage:         File
When:            2016-02-22 12:02:56
Catalog:         MyCatalog
Priority:        10
Plugin Options:  *None*
OK to run? (yes/mod/no): mod                       <-------------------
Parameters to modify:
     1: Level
     2: Storage
     3: Job
     4: Fileset
     5: Restore Client
     6: When
     7: Priority
     8: Bootstrap
     9: Where
    10: File Relocation
    11: Replace
    12: JobId
    13: Plugin Options
Select parameter to modify (1-13): 13              <-----------------
Automatically selected : mssql: database=db29187
Plugin Restore Options
instance:            *None*
database:            *None*
username:            *None*
password:            *None*
domain:              *None*
hostname:            *None*
authtype:            *None*
recovery:            *None*               (yes)
stop_before_mark:    *None*
stop_at_mark:        *None*
stop_at:             *None*
restricted_user:     *None*               (no)
verify:              *None*               (no)
connection_string:   *None*
checksum:            *None*               (no)
driver:              *None*               (SQL Server)

Use above plugin configuration? (yes/mod/no): mod  <------------------
You have the following choices:
You have the following choices:
     1: instance (Instance used to restore)
     2: database (New database name)
     3: username (Username used for restore)
     4: password (Password used for restore)
     5: domain (Domain name of user (default to local))
     6: hostname (Server ODBC parameter (default to (local/localdb)))
     7: authtype (Authentication type (server or windows))
     8: recovery (Start Recovery)
     9: stop_before_mark (Stop the recovery before a mark (STOPBEFOREMARK). {lsn:lsn_number | mark_name})
    10: stop_at_mark (Stop the recovery at a mark (STOPATMARK). {lsn:lsn_number | mark_name})
    11: stop_at (Stop at (STOPAT). {datetime})
    12: restricted_user (Restrict access to the restored database)
    13: verify (Verify backup integrity)
    14: connection_string (ODBC Connection string)
    15: checksum (Restore using the WITH CHECKSUM option)
    16: driver (ODBC Driver Name)

Select parameter to modify (1-15):

The Plugin restore options are:

instance=<str> The instance name used to connect to the MSSQL instance. This parameter is optional, and if not set, the restore will use the value set during at the backup time. By default, the instance name is “MSSQLSERVER”.
database=<name> Specifies the name of the databases to restore. This parameter is optional. By default, the plugin will use the where option to determine the name of the new database. If both where and database are set to a valid database name, database will be used. A valid database name can contain the following characters: A-Za-z0-9#_
username=<str> The username used to connect to the MSSQL instance. This parameter is optional, and if not set, the restore will use the value set during at the backup time.
password=<str> The password used to connect to the MSSQL instance. This parameter is optional and if not set, the restore will use the value set during at the backup time.
domain=<filestr> The domain used to connect to the MSSQL instance. This parameter is optional and if not set, the restore will use the value set during at the backup time.
hostname=<str> The MSSQL server host name.
authtype=[windows | server] The authentification type. Windows is default.
recovery=<Yes/no> Specifies if the database will use the RECOVERY or the NORECOVERY option during the restore. By default, the restored database will be recovered.
stop_before_mark=<markname> Use the WITH STOPBEFOREMARK = ’<point>’ clause to specify that the log record that is immediately before the mark is the recovery point. The point can be a LSN number or a mark_name.
stop_at_mark=<markname> Use the WITH STOPATMARK = ’<point>’ clause to specify that the marked transaction is the recovery point. STOPATMARK rolls forward to the mark and includes the marked transaction in the roll forward. The point can be a LSN number or a mark_name.
stop_at=<datetime> Use the WITH STOPAT = ’<datetime>’ clause to specify that the date time is the recovery point.
restricted_user=<No/yes> Use the WITH RESTRICT_USER clause to restrict access to the restored database. The default is no.
connection_string=<str> Specifies the ODBC connection string. This parameter is optional.
checksum=<No/yes>

Available since Bacula Enterprise 8.11.6

Use the WITH CHECKSUM clause to the restored database. The default is no.
driver=<str>

Available since Bacula Enterprise 10.2.3

The driver name used in the ODBC connection string. Default is S̈QL Server.̈ If the connection_string option is set, it will overwrite this option.

On BWeb Management Suite, the Plugin Options are available in the restore tab.