Database corrupt reasons and precautions

gayheadavonΔίκτυα και Επικοινωνίες

27 Οκτ 2013 (πριν από 3 χρόνια και 10 μήνες)

114 εμφανίσεις




Page:
1

Author:

Jaleel Nizamudeen /
jaleel@gofrugaltech.com

www.gofrugal.com

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
nt


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


Properties


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
-
Ctrl
-
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



Page:
2

Author:

Jaleel Nizamudeen /
jaleel@gofrugaltech.com

www.gofrugal.com

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
CORRUPTION ISSUES.


Please remember that "
Prevention is better than cure” [in some data corruption cases it cannot be cure]


References,

How to Recognize, Repair and Prevent Database Corruption


http://www.quickanswer.com/corrupt.htm


Data corruption article in Wikipedia.org

http://en.wikipedia.org/wiki/Data_corruption


Reasons for Disk

errors

http://indico.cern.ch/getFile.py/access?contribId=3&sessionId=0&resId=1&materialId=paper&confI
d=13797



Disk failures in the real w
orld

http://www.useni x.org/events/fast07/tech/schroeder/schroeder_html/i ndex.html


Microsoft Access databases are subject to occasional corruption issues,

http://www.datarevive.com/support/kb/kb2202.htm


Some times the the following link will help for Access database corrupt,

http://download.microsoft.com/download/access97/utility1/1/WIN98/EN
-
US/JETUTILS.EXE


Download JETCOP utility for compress Access database,

http://support.microsoft.com/kb/273956