Backing up a database

Backing Up Theatre Manager

Theatre Manager consists of two components, the program and the database. Depending on the purpose of the backup, you may need to save one or both. For example, if you are:

Upgrading to a new version, you must back up both the database. We also recommend that you save at least one copy of an older version of the program until the upgrade is complete.
Doing daily backups, you need only backup ther database files.
Doing a year-end backup or point-in-time image of the system, you must backup both the program and the database. Why? If you only back up the datafiles to a device like a Zip or CD drive and you want to look at them some time in the future, there is no guarantee that a future version of the program could read the database and produce the same results. This is prudent practice for all important data like accounting files, word documents, graphics files, etc.

Saving a Database

The database is one or more file segments for your site. The file name for segment will end in .DF1, .DF2, .DF3, etc. depending on how many segments you have. If you only have one segment, it will end in .DF1. If you have two, the first will end in .DF1 and the second in .DF2, etc.

You must make a copy of all segments to make a complete backup. If you only successfully back up one segment, then the copy of the database will not be accessible and we cannot do anything to recover it for you. Please make sure you copy all segments.

By convention, these files usually are found in a folder called 'Box Office' and are the name of your venue.

Since version 5, there is also a file called Transact.DF1 that is part of Theatre Manager. It contains the transactions for each day and must be backed up as well for a complete history. Note: it is possible to use this files in special ways if you are trying to recover the main database. Please contact Arts Management Systems if you have any need to recover a database so that we can assist you reconstruct your business day.

Summary. To backup a database

Find the folder containing your database segments. It is probably called 'Box Office' and can be found on your network.
Ensure that the folder contains files ending in .DF1, .DF2, etc.
Ensure it also contains files called TRANSACT.DF1, TRANSACT.DF2, etc.
Copy those files to a CD, Zip Drive or another machine by dragging the entire folder to the desired backup location.

Saving the Program

Macintosh

Find a folder on your computer called TM ƒ. For version 4, it is installed in the Macintosh HD icon. In version 5, it is installed in the 'Applications' folder. You will most likely find Theatre Manager in one of those locations unless you have moved it.

To make a copy of the program, copy the entire TM ƒ folder to another folder, Zip Disk, CD or network drive.

Summary: Your program is most likely in Macintosh HD:Applications:TM ƒ

Windows

Double click on 'My Computer' (unless you renamed it) and look for a folder called 'Program Files'. In that folder is a directory called 'TM' which contains the program.

To make a copy of the program, copy the entire TM directory to another folder, Zip Disk, CD or network drive.

Summary: Your program is most likely in My Computer:Program Files:TM

Backup Strategies

There is a good discussion of backup strategies and decent backup devices on the internet. Please read about why you should do backups and how often. We recommend upwards of 20 to 30 backups over a year.