design a backup database

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
mkdjoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jjmcdCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jjmcdCommented:
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
mkdjoAuthor Commented:
Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Hardware

From novice to tech pro — start learning today.