Rebuilding the Database Connections

By this step your Main and Transaction Databases will both be copied into the new files you created. Now the data within them must be reassociated.

  1. Make a copy of the new data files and new transaction files

    2. Click Here for more information on physically copying the database files

  2. Open Theatre Manager

  3. Click the Change Data File Button

    4.  

  4. Select the new database file you created

  5. Click Open

    6.  

  6. Log on to Theatre Manager

    7.  

  7. Go to data utilities and check that all data appears to be there

    8. Note, the data has only been recovered at this point, it is still not usable.

  8. Under the DB Utilities pop-upselect Verify All DB Connections


    A popup window will appear

  9. Click Yes to continue

    10. This will go through the data and perform step 2 of the normal database copy routines.... in other words it will connect the data together.

    At the end of the last step, there is a good chance that you will have recovered the database and all the records in it. This will be a pristine database.

  10. Exit Theatre Manager

  11. Create a folder to hold the old database

    12. Name it something like "OldDB-yy-mm-dd". By including the date you will know how old the database is and if it has been over 2 weeks without any problems it can be deleted.

  12. Move the original database to this folder

    13. Click Here for more information on moving the database.

  13. Move the database and ALL OF IT'S SECTIONS to your regular TM database location

    14. Click Here for more information on moving the database.

  14. Start Theatre Manager

    15. If you renamed your database to the original name you can login as ususal. If not you will have to use the change database button and navigate to the database.

    Go into File -> Statistics, and print the list of files. Compare this list with the one you printed in the 6th step at the top of this page, and check the record counts to make sure things match.

    Once you are satisfied that this new database is ready for use, move the old database into a new folder, called Old Data 021008 (or something similar). Click Here for more information on creating folders.

    Then move the new databases into the folder where your data normally resides, and allow users to log into it to begin any data entry that needs to be done. Click Here for information on moving your database.