Jaleel Nizamudeen /
Database corrupt reasons and precautions
The database is very sensitive and very important as all the information will be there,
Microsoft Access & SQL
databases are subject to occasional corruption issues,
but these can be minimized with careful manageme
Causes of SQL & Access data corruption?
There are many ways a database can become corrupt. Some are user
related,.. There are hardware and/or
environmental causes such as these:
Hard disk error
Network error or failure
Power glitch (power
loss, dip, or surge)
OS related issues...
User actions like these can corrupt a database:
Rebooting or switching off PC when a database is open
PC crashing (freezing) when a database is open
Precautions to take,
1. Consider a power con
ditioner or UPS for each workstation
2. Shutdown all systems safely
Close applications in Clients first [If exist] and shutdown the clients
Close it in Server @ last
Shutdown the server system
3. Having anti virus software in all systems and enabl
e firewall in all machines
4. Taking database backup in external media [i.e.. CD/R, CD/RW, Flash drive...]
5. Verify the Network connections regularly, Data loss must be 0 in network ping
6. Use CHKDSK [Check disk] tool regularly
e drive and right click
Goto Tools tab
Click Check now button
7. Verify network connections regularly, verify no loss in PING systems from each other
Rules for Preventing Corruption,
(1) Always exit the database or application correctly a
nd avoid using Alt
Delete to terminate the application or
database unless you absolutely have to.
(2) Avoid losing power to the computer accessing or containing the database.
(3) Executing the 'Compact and Repair' options inside an Access database reg
ularly is recommended as a procedure
to prevent corruption. This should certainly be executed every week for a database that is being used daily.
Compacting the database removes unwanted space, reindexes tables and improves efficiency.
(4) Avoid mixing ope
rating systems in a multi
user environment. For example, Windows 98 with Windows 2000. In this
case, it is recommended that you place the database on a Windows 2000 or Windows NT machine and disable
(5) If the database is primarily
used by one person but the database file is located on a network, it is recommended
that the file be placed on your local machine. This will prevent corruption caused by any unwanted disruptions in
put simply, its one less thing that
can go wrong.
(6) Consider disabling opportunistic locking on the file server it is Windows NT or Windows 2000 based.
(7) Do not run IPX on Windows NT Server where Jet databases are located across the network and the client is
Microsoft Windows 95 with IP
X/SPX. Instead run TCP
IP on the Windows NT Server and a dual protocol stack of IPX
Jaleel Nizamudeen /
IP on the Win95 client. (Windows NT to Windows NT with IPX/SPX will not cause the problem, nor will
Novell to any client.)
Please do understand that GOFRUGAL TECHN
OLOGIES is not responsible and not cause for the DATABASE
Please remember that "
Prevention is better than cure” [in some data corruption cases it cannot be cure]
How to Recognize, Repair and Prevent Database Corruption
Data corruption article in Wikipedia.org
Reasons for Disk
Disk failures in the real w
http://www.useni x.org/events/fast07/tech/schroeder/schroeder_html/i ndex.html
Microsoft Access databases are subject to occasional corruption issues,
Some times the the following link will help for Access database corrupt,
Download JETCOP utility for compress Access database,