3.2

Table Of Contents
Creating and Restoring Database Backups
33
n
Prior to Interplay Engine v1.2.4, storing backups on shared storage was not recommended
because of the large number of small files included in the backup. However, the backup
mechanism included with Interplay Engine v1.2.4 or later significantly reduces the number of
files created in the _PropertyStore folder, which reduces the amount of storage required.
Alternatively, you can store the backups on an external file server. You need to use a UNC
path when you specify the location. Make sure the Server Execution User has read/write
access to this external file server and the backup folder. See
“Troubleshooting the Server
Execution User Account” on page 229
.
Cluster systems: The default path is
- S:\Workgroup_Databases\AvidWG\_Backup
On cluster systems, Avid recommends that you specify \\?\d:\backup as the path for
Interplay backups. (This syntax, with a question mark, is known as a Long UNC or UNCW
path, and allows for more characters than the 260-character limitation of the short UNC
path.) This path will create backups on the local drive of the active node, rather than the
Infortrend, thus avoiding a single point of failure.
n
SR2400 systems were shipped with 73 GB drives, which are too small for regular backups. These
systems should be upgraded to include larger drives.
Ensure that the backups are working and actually creating backups. To test the backup,
check that the backup subfolders databasename_date_time are being created at the specified
times (according to the backup configuration) and that these subfolders are not empty. Every
backup should create its own subfolder.
For example, on a non-cluster system, your backup folders might be created in the following
location:
- D:\Workgroup_Databases\AvidWG\_Backup
A backup subfolder might be named AvidWG_2007-05-22_03-00.
Enable a different backup mechanism, such as tape backup, for all folders except the
_Database and _PropertyStore folders (see the table at the beginning of this topic). The
_Master folder of each database is the most important for the tape backup. Do not include
the _Database and _PropertyStore folders of each database in the tape backup.
After a Complete backup, copy the backup folder to offline media to prevent data loss.
You can do this as a separate step or as part of a backup of the complete database to offline
media (see the next bullet). Use a backup tool (such as Robocopy or 7-Zip) that can handle
long path names and does not use excessive bandwidth, to avoid slowing down activity on
the Interplay Engine. (See
“Using an Archiving Tool for Backup” on page 40).