3.2

Table Of Contents
Creating and Restoring Database Backups
42
Restoring an Earlier Version of a Database
Restoring a backup version of the _Database and _PropertyStore folders returns a database to the
state it was in when the backup was created. Before restoring a database, make sure that it is
really necessary, because changes since the backup will be lost.
To restore a backup, you need to run the InterplayRestore tool in a Command Prompt window.
The InterplayRestore tool is installed in the following folder:
C:\Program Files\Avid\Avid Interplay Engine\Server
The tool includes in-line help that describes all options for using the tool.
The following topics provide instructions for restoring an earlier version of a database:
“Restoring a Complete Backup or a Fast Backup” on page 43
“Using the InterplayRestore Tool on the Interplay Engine Server” on page 46
“Database Restore Session Example” on page 49
“Using the BackupArchive Tool to Restore Files” on page 50
“Restoring Archived Log Files” on page 53
You cannot restore parts of a backup, for example, a specific sequence or folder. You can restore
only a Complete backup or a Fast backup.
How the Restore Tool Works with Streamed Properties Files
Beginning with Interplay Engine v1.2.4, the Interplay backup mechanism consolidates the
streamed properties files (all files in the _PropertyStore folder) into large “archive” files. These
files are written into the _PropertyStore folder of the corresponding backup folder. The archive
files are named streamed_propx.bar, where x is replaced with an increasing number starting with
1. The files are about 1 GB each, except for the last one (with the highest suffix number), which
can be smaller. The exact file size varies depending on the size of the individual streamed
property files, because a single streamed property file is never split up between two .bar files.
The backup mechanism also writes a file named streamed_prop.bin in the same folder. This file
contains a directory of all streamed property files contained in the backup and is used only by the
BackupArchive tool (see
“Using the BackupArchive Tool to Restore Files” on page 50). The .bin
file is not required by the InterplayRestore tool.
The InterplayRestore tool is able to work with both the consolidated streamed property files as
well as a backup created by an earlier version of the Interplay Engine. The tool looks for the
streamed_prop1.bar file in the _PropertyStore folder of the backup. If this file does not exist, it
assumes that the backup was created by an earlier version of the engine and resumes with the
restore procedure in the same way as earlier versions of the restore tool. Otherwise, it restores the
streamed properties from the consolidated .bar files.