How can you protect huge amount of data and avoid data corruption from power outage while the modification in database is on process? if there is any database management system that can backup the original value of the records upon this occurrence please specify.
Yes, we better take a prevention to avoid risk of data corrupt or lost data. Especially from unexpected problem. These are some tips:
Backup
Practice good working habits
Use an anti-virus software and keep it updated
Protect against power surges with an UPS
Keep your machine dry in a dry, shaded, dust-free and well-ventilated area
Do not over-tweak your system
Avoid moving your computer or notebook when it is in operation
Safeguard your computer
Practice disk maintenance
Preempt failure
Do not listen to tell-tale technique
for the complete information, you can go here:
http://www.adrc.com/sm/prevent_data_loss_tips.html
About database management system, you can find and compare them here.
The most common causes of data corruption and loss are; Power outages or other power-related problems and Improper shutdowns. Thus results to a corrupted files and or missing.
Hence, we have certain strategies to minimize the risks of data corruption and loss.
1. Implement a comprehensive Backup and Recovery Solution and use it regularly. Always scan/update anti-virus software your computer and
2. Perform the small amount of regular maintenance.
3. Power outages and other power problems — surges, spikes, brownouts, and the like — can not only cause data corruption but damage your hardware. So I suggest you to use UPS “uninterruptible power supply” to delay the power of shutting down your computer so you have time to properly shut down your pc.
4. Lastly, to avoid data loss and corruption, always do save what you are doing from time to time.
