Restore Selected or Renamed Databases Using ^DBREST

Choosing 2 from the ^DBREST menu is equivalent to choosing 3 from the ^BACKUP menu. This option lets you select which directories to restore from the backup medium. It also allows you to restore a database to a different directory name or to a different device.

Note:

If you are restoring mirrored databases, review Mirrored Database Considerations before you perform this procedure.

The following example shows how to restore selected or renamed directories.

Choose option 2 from the ^DBREST utility:

%SYS>Do ^DBREST
 
                              DBREST Utility
         Restore database directories from a backup archive
 
Restore: 1. All directories
         2. Selected and/or renamed directories
         3. Display backup volume information
         4. Exit the restore program
    1 => 2

Indicate whether you want to suspend InterSystems IRIS processes while restoring takes place. InterSystems recommends suspending processes.
```
Do you want to set switch 10 so that other InterSystems IRIS processes
will be prevented from running during the restore? Yes =>
```

Specify the first file from which to restore. You can press <Enter> to accept the default file, which is the last full backup.

Specify input file for volume 1 of backup 1
 (Type STOP to exit)
Device: c:\iris-install\mgr\backup\IncrementalDBList_20180323_001.cbk =>

Check that the description of the backup is correct and verify that this is the file you want to restore.

This backup volume was created by:
   InterSystems IRIS for Windows (Intel) 5.1
 
The volume label contains:
   Volume number      1
   Volume backup      MAR 23 2018 11:03AM Full
   Previous backup    MAR 23 2018 09:52AM Full
   Last FULL backup   MAR 23 2018 09:52AM
   Description        Incremental backup of all databases that are in the backup
                      database list.
   Buffer Count       0
Is this the backup you want to start restoring? Yes =>

As the utility prompts you with directory names, specify which databases you want to restore, and in which directories you want to restore them:

For each database included in the backup file, you can:
 
 -- press RETURN to restore it to its original directory;
 -- type X, then press RETURN to skip it and not restore it at all.
 -- type a different directory name.  It will be restored to the directory
    you specify.  (If you specify a directory that already contains a
    database, the data it contains will be lost).
 
c:\iris-install\mgr\ =>
c:\iris-install\mgr\irisaudit\ =>
c:\iris-install\mgr\test\ =>
c:\iris-install\mgr\user\ =>

After responding to each directory prompt, you see the prompt:
```
Do you want to change this list of directories? No =>
```
Answer Yes if you want to edit your choices, or press Enter to confirm them.
The process then continues the same as the procedure for restoring all directories, as specified in the previous section.

You can use this procedure to restore a backup performed on different system from the one on which you are restoring it.

Restoring Databases Using the Backup History

Restore All Databases Using ^DBREST