Creating a New Transaction Database

This procedure creates a new empty transaction database the same size as your original database. Depending on the extent of the damage you may not need to rebuild your transaction database.

1. From the File menu select New Data File

   

2. Save the data file called 'newfile.df1' in its own directory

   

3. Click on the new transact file that you created in the top window

   

4. Under the Utilities menu select Data File Tools >> Examine Data File



5. Make sure the window title that popped up says 'data file -' and your new file name

   

6. Step 3 will add a Data File menu to the main menu bar. From that menu select Change Data File Size



7. Change the first segment size to 128000. If the window closes, open it again using step 5



8. Click 'Add Segment'. Select the directory in which to create the new segment

   

9. Make the second segment 524288 (or whatever the largest number it will allow you to put in)

Note The first segment has the ability to auto-expand as it needs to. All other segments cannot and are set to the maximum size using this step.



10. Repeat steps 8 and 9 as many times as you need to so that you have the same number of segments as the original transaction file

 

11. Click the OK Button

This will extend the data file's segments.



Click Here for the procedure to reconstruct the transaction database.