#11 – Avoiding Data File Recovery nightmares

It is every developer’s worst nightmare: database or file corruption.  Hardware and systems are not completely infallible so sometime, somewhere, when you least expect it you will have to face the horror and pain of data file/table corruption and loss.

File corruption can happen even if you are following all the recommended best practices. It is not just a software crash that could damage data files; it could be a power outage, your computer crashing, or even just the size of your data file, as very large files have a higher risk of corrupting.

While there is no substitute for backing up your data on a regular basis, even those with good backup regimens, can find themselves confronted by the stomach-churning feeling of data loss.

PxPlus is somewhat unique in the industry in that we designed our native file format from the ground up with the goal of immunizing from data loss and allowing application system to continue to run even when suffering file integrity issues.  Of course, nothing is perfect and every situation is unique, which is why we are offering a session on how to recover your files.

The Data File Recovery session will delve into the internals of PxPlus data tables, their structure, and how the system tries to assure maximum availability even when portions of the file structure may be damaged.

We will also look at a variety of tools at your disposal that can be used to correct and recover your files from the simple file rebuild directives to the external file rebuild utilities.

For those of you that love understanding the bits and bytes, we will also look at how you can manually recover selected pieces of your data files and tables so as to avoid having to take your systems down to rebuild complete data sets.

Finally, we will look at how you can use the file splitting capabilities of PxPlus to help minimize any potential down time by segmenting your data into historical and active data components.

If you want to sleep better at night knowing that you are armed with the tools and information you need to recover data in the event of a catastrophic system failure, this session alone is reason enough to attend DireXions 2017.

Bookmark the permalink.

Comments are closed.