Restore Database with a New Name

Bacula Enterprise Only

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

To restore a database with a new name, it might be required to relocate database files on disk. It depends if the original database is still present.

If the original database is no longer available, the where parameter or the “Plugin Options” database can contain the new database name, and the plugin will automatically handle the database creation with the new name.

If the original database is still required, the where parameter is used to relocate files on disk, and the new database name should be be set with the “Plugin Options” menu with the database option. The layout.dat must be selected in the restore tree.

* restore where=c:/tmp replace=always
...
Using Catalog "MyCatalog"
Run Restore job
JobName:         RestoreFiles
Bootstrap:       /opt/bacula/working/127.0.0.1-dir.restore.1.bsr
Where:           c:/tmp
Replace:         Always
Fileset:         Full Set
Backup Client:   win2008-fd
Restore Client:  win2008-fd
Storage:         File
When:            2015-12-14 09:53:36
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*
recovery:            *None*               (yes)
stop_before_mark:    *None*
stop_at_mark:        *None*
stop_at:             *None*
Use above plugin configuration? (yes/mod/no): mod  <------------------
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: recovery (Start Recovery)
   7: stop_before_mark (Stop the recovery before a mark (STOPBEFOREMARK).
   8: stop_at_mark (Stop the recovery at a mark (STOPATMARK).
   9: stop_at (Stop at (STOPAT). {datetime})
Select parameter to modify (1-9): 2                <------------------
Please enter a value for database: newdb           <------------------
Use above plugin configuration? (yes/mod/no): yes  <------------------

Using Catalog "MyCatalog"
Run Restore job
JobName:         RestoreFiles
Bootstrap:       /opt/bacula/working/127.0.0.1-dir.restore.1.bsr
Where:           c:/tmp
Replace:         Always
Fileset:         Full Set
Backup Client:   win2008-fd
Restore Client:  win2008-fd
Storage:         File
When:            2015-12-14 09:53:36
Catalog:         MyCatalog
Priority:        10
Plugin Options:  User Specified
OK to run? (yes/mod/no): yes                       <-----------------