Overclock.net - An Overclocking Community - View Single Post - Database stopped working in open daylight

View Single Post
post #2 of (permalink) Old 05-13-2018, 06:01 AM
New to Overclock.net
Chadams's Avatar
Join Date: May 2018
Location: CA, Walnut
Posts: 1
Rep: 0
As alternative method, look at steps below:
You need to create an environment under which the table is NOT validated when it is opened. This can be achieved by the command -SET TABLEVALIDATE TO 0. Now you can easily open your tables.

These are some “Prevention Steps” to prevent your data from corruption:

Try to put a code in your program that automatically creates a duplicate copy of your tables (columns & rows), index files and databases.
Set-up a back-up routine.
Inform the user to properly shutdown the computer and regularly perform back-up.
Use UPS for power back-up.
Chadams is offline