?
Solved

design a backup database

Posted on 2000-02-06
3
Medium Priority
?
216 Views
Last Modified: 2010-04-26
Regularly I take a backup of my computer with a streamer tape. Now I want to list all the files with date, etc. in a backup database file with access. I know, this is used to be done by some network admins. What experience do you have with this? What is the structure of this database?
Thanks
Martin
0
Comment
Question by:mkdjo
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
jjmcd earned 150 total points
ID: 2494284
It should be fairly obvious, it's whatever data you can get from the tape (or more likely, the backup reports).  However, commercial, large-site backup programs aren't likely to use a relational database (like Access) because the tree structure of the directories you normally want to explore in such a program is pretty unweildy in that format.  More likely they will build some sort of unbalanced tree and make that persistent through some proprietary means.

If all you want is reports, however, then simply keeping the directories as a separate column is probably pretty good, and the best you can do in a RDb.

I've done this in the past, using relational databases or flat files, and it is pretty unsatisfying, although there are some sorts of reports/searches that can be useful.

In a little while I'll post the DDL for what *I* would want.
0
 
LVL 3

Expert Comment

by:jjmcd
ID: 2494326
OK, this is what I would do, having given it all of ten minutes thought :-)

CREATE TABLE BACKUPS
    (
    SAVESET_NAME CHAR CONSTRAINT KEY1 PRIMARY KEY,
    TAPE_NAME CHAR NOT NULL,
    BACKUP_DATE DATE
    )
 
CREATE TABLE FILES
  (
  SAVESET_NAME CHAR CONSTRAINT FK1 REFERENCES BACKUPS,
  DRIVE CHAR NOT NULL,
  DIRECTORY CHAR NOT NULL,
  FILENAME CHAR NOT NULL,
  FILE_DATE DATE,
  FILE_SIZE NUMBER
  )

This assumes that your backup set names are unique (they should be!)  You might add a (manually entered) description to the backups table, and depending on your OS/Backup software, it might be nice to also include the file attributes in the files table.

Of course, I would create additional views to report from.
0
 

Author Comment

by:mkdjo
ID: 2560485
Thank you.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
For years I have put up with a wireless mouse that consistently disappears or is non-responsive.  This is the story of how I discovered it wasn't really the mouse!
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Suggested Courses

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question