|
Restoring corrupt databases
Overview
If you are reading this, unfortunately there has been a corruption
in your data file.
Corruption is not caused by anything you have done. It can occur
from hard drive failures and operating system issues.
However, you can minimize corruption issues by:
--following prompts to exit/restart on certain maintenance activities
--keep all data files (brd) local to your machine. Sharing and accessing
a data (brd) file on a network drive will cause corruption. The database (brd) needs
to be on your local workstation.
Please print these directions and close Treasury Software before
you begin.
If your software was installed after 2010, you will have an automated restore feature. Otherwise, please follow the directions for Manual Restore.
1. Start Treasury Software and enter into the Sample account - or any account that you do not need to restore.
2. From the main menu select File > Restore.
On the pop-up window select the account you want to work with. Click 'Display backups'.
3.
Now select a backup. They will be sorted with the most current at the top. Select the top one, then click 'Restore'. Note: Before you click 'Restore', close Treasury Software if you (or the system) have not done so already.
4. Start Treasury Software and attempt to enter the account. Perform
the activity that you previously triggered the corruption warning/error
message.
If you have not triggered the warning/error message - congratulations.
Stop here.
If the error persists, repeat the steps above by selecting the next available backup file.
Note: If you have not turned 'On' your backup routines, the system has made emergency backups, and will have placed them in the \archive folder.
Backup your backups
Start Windows Explorer and navigate to the working directory of
Treasury Software. The default location may vary slightly by your Operating System. On Windows 7 and Vista:
C:\Users\Public\Treasury Software\Data
On Windows XP, the
data would be in:
c:\Program Files\Treasury Software\Treasury Desktop\Data
Upon entering the data subdirectory, you will see that there are
up to four similarly named files for each account that you have.
You will rename each of these files to protect them from being overwritten.
For example, if you have an account called 'Checking', please rename
each file
| From |
To |
| Checking.brd |
CheckingCorrupt.brd |
| Checking.br1 |
Checking.br5 |
| Checking.br2 |
Checking.br6 |
| Checking.br3 |
Checking.br7 |
Also, backup these files to another location - either on your workstation
or network.
Restore the most recent backup and test
Rename Checking.br5 --> Checking.brd
Start Treasury Software and attempt to enter the account. Perform
the activity that you previously triggered the corruption warning/error
message.
If you have not triggered the warning/error message - congratulations.
Stop here.
If the error still exists...
Restore the next most recent backup and test
Delete Checking.brd (you did make a backup, didn't you?)
Rename Checking.br6 --> Checking.brd
Again, start Treasury Software and attempt to enter the account.
Perform the activity that you previously triggered the corruption
warning/error message.
If you have not triggered the warning/error message - congratulations.
Stop here.
If the error still exists...
Restore the next most recent backup and test
Delete Checking.brd (you did make a backup, didn't you?)
Rename Checking.br7 --> Checking.brd
Again, start Treasury Software and attempt to enter the account.
Perform the activity that you previously triggered the corruption
warning/error message.
If you have not triggered the warning/error message - congratulations.
Stop here.
If you still have an error, you will need to find a prior backup.
Perform the same routine with those backups.
| 
