[AccessD] Keeping your db in tiptop shape

In general:

A. Create a backup schedule and make sure it is maintained.

B. Verify your database on a regular basis.

C. Rebuild indexes and/or update database statistics on a regular basis.

D. Defragment your hard drive on a regular basis.  Note that open files
cannot be defragmented, so you need to shut your database down before doing
so.  If this this is not an option because of the length of time, defrag the
drive first to create the most amount of contiguous free space possible,
then close, move the data base files, and re-open the DB.

E. If your R/DBMS system uses journaling files, make sure they are on a
different drive then the main database files.

F. Test that you are able to recover from your backups.

G. Periodically review index usage and determine if changes are required.


Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, April 14, 2009 12:33 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Keeping your db in tiptop shape

I'm going to write about tasks that keep a db in shape -- the db doesn't 
have to be Access, but can be specific to Access or any database really. If 
it works out, I'll give credit where possible -- I like doing that and the 
readers like it too, but I can't promise anything.

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com