Database corrupt reasons and precautions

gayheadavonNetworking and Communications

Oct 27, 2013 (4 years and 8 months ago)




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

Memory error

Network error or failure

Power glitch (power

loss, dip, or surge)

Virus issues

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


My computer

Select th
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
opportunistic locking.

(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
network connectivity

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 /

and TCP
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

Reasons for Disk


Disk failures in the real w

http://www.useni 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,