Keeping genealogy database in tip top shape

Keeping my genealogy database in tip top shape

This post is aimed at Legacy users but even if you use a different genealogy program most of this stuff will still make sense.  I am a little OCD about keeping my database file in tip top shape.  Here are the things I do on a regular basis.

 1) I backup my files every day that I am working in them and sometimes more than once a day if I am adding a lot of data.  I keep my ten most current backups and I delete the older ones.  I keep my backups on SkyDrive. My files are also automatically saved to Carbonite so I have them in two places.  I have 23 years worth of research in my database file and if I ever lost that I might have to throw myself off of a cliff. 

2) Before I backup my files I do a List Cleanup and a Check/Repair.  I already have Legacy automatically renumbering my RINs and MRINs which compacts my file even further.  Routine Check/Repairs are very important.  It is similar to defragging your hard drive.  As you add data, delete data, merge data the information gets a bit scattered.  A check/repair will compact the file and make it run more efficiently.  It can also fix most of the common database errors that occur over time.

3) Once a week I address every issue that is on my Potential Problems list and either do the research needed to clear the problem or if it isn’t a problem I mark it as such.  I don’t like to let the Potential Problems get out of control because if you wait too long to address them you will feel a bit overwhelmed.  Don’t forget to take the time to go through the Potential Problems options to get them set exactly like you want so that it is only picking up legitimate problems that you need to address.

4) Once a week I look for duplicates in my file.  I either do the research needed to determine whether or not they are actually duplicates or if I know for a fact that they are not, I mark them as such.  I love this feature in Legacy.  When you have a large database you can easily add someone as a spouse not knowing that you already have that same person as a child in another family.  This is especially true when you are working in areas of the country where it is common for people to marry relatives.

5) Once a week I review my To-Do list.  Is there anything I forgot to close out?  Is there anything that I said I needed to do but haven’t done yet?  Have I not heard back from someone in a reasonable amount of time meaning I need to send my request again?  This is another area you want to stay on top of or it can become overwhelming. 

6) I close my file at night.  I don’t leave my database open for extended periods of unsupervised time.  If Windows decides to update and reboot with your file open it could cause trouble.  Before I shut down for the day I do the first two items on this list. 

7) I change my color scheme from time to time.  This has absolutely nothing at all to do with maintaining your database but it does keep me from getting bored Smile 

 Copyright © 2014 Michele Simmons Lewis


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s