Introducing PTWin

Introducing
PTWin32

Support Services
Support
Services

Downloads
Downloads

User Tips
User Tips

Contact Us
Contact Us

Introducing PTWin
Home

  PTWin User Tips / System Administration 

Pushing the Post Button

History doesn't repeat
But it does rhyme
Unintended rollbacks resulting from full data restores

Tip #: 5.4.143
Ver(s):PTWin32, V2, V1

Life is full of unintended consequences and the administration of a PTWin32 installation is no exception. In order to make things simple people often take a broad brush approach to solutions. Often this is the best course of action but sometimes your broad brush will paint something inadvertently.  Something you would rather have left alone.

Consider the following scenario: You are a good and true PTWin32 user who makes regular backups of your data. One day there is a power surge and failure that hopelessly corrupts some of your PTWin32 data.

You go to your backups and instead of hunting and pecking to determine which tables are corrupt you restore the entire \Data directory. Then you discover only the Parcel table was corrupt.

All non-parcel work done since the last backup is gone and must be redone. This can be compounded if you’ve chosen to modify the fields that appear on the Additional Info and Permit Info tabs of PTWin32 windows since the last backup.

Most people don’t consider things like selection values, custom fields, fee schedules, system settings, and security data when restoring from backup, but these things do represent data stored in your PTwin32 tables.

If you overwrite all data you lose your administrative changes as well as your working data. Keep that in mind the next time you experience a crash. A little bit of work up front may save you a lot of catch-up work after the restoration.

 

 

Return to System Administration menu