Database Backup Tips and Strategies

Posted: April 4, 2016 in Uncategorized
Tags: , , , , , , ,

Every now and then it feels like talking about the database is a good thing to do. It’s mysterious. It’s helpful. And with a little information and some TLC, your database can grow up to be big and strong.

One box missing from rows of boxes on shelves

Let’s recap: The ACDSee database stores information about your files, including EXIF information, file name and folder location, thumbnails, categories, ratings, and any other information you add using the Properties pane. The more information you store in the database, and the more time you spend entering that information, the more important it is to back up your database. A real database nerd might even go so far as to say it’s worthwhile to have a good strategy for managing your backups. Losing hours of work to a system crash or other uncontrollable event is something that should, and can, be avoided. But you didn’t hear that from me. What do I look like? A database nerd? How dare you…

Backup Schedule

How often should you backup? All databases are beautiful and unique. And it really depends how often you add or change information contained in your database. I’d say it’s fair to declare that you should backup as often as you want to avoid retyping data.

Luckily there’s a backup reminder setting you can take advantage of. Go to Tools | Options | Database. On the Database page of the Options dialog you can set how regularly you would care to be reminded. For business environments, though, you really ought to consider backing up every day. It’s one of the easiest ways to avoid an embarrassing time out in the corner… That’s how offices work, right?

When you’re getting ready to do something big, such as importing information from another ACDSee user, or converting a database from a previous version of ACDSee, this is a choice time to prompt a backup. Go to Tools | Database | Back Up Database…

Backup Location

Next, consider not just when or how often you’re backing up, but where to. ACDSee takes pretty good care of you by creating a new folder for each day if you are backing up to your hard drive. This helps to avoid overwriting your backup, and gives you several increments from which you can restore. Also helpful is a monthly backup that is stored in a different physical location than your computer, such as a network drive. You never can be too careful.

Backup Size

To keep the size of the backup small, choose to back up database information only. This can be configured in the Database Backup Wizard (Tools | Database | Back Up Database…). But also don’t forget to back up your images separately, also on a regular basis.

Backup Options

Do you want to include thumbnails? What types of files do you want to back up? In the Database Backup Wizard, familiarize yourself with the options in order to decide which backup style is the right one for you. For more information about your options, see here.

Comments
  1. Really had to say I’m pleased I happened upon your page!|

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s