Server back-up logging database

[Stramec]

Hi

I was wondering if anyone fancied throwing some ideas about for a new
task I've been set.

I'll say now I'm by no means an Access guru, so please bear that in
mind.

Basically I have been asked to create some form of database, that will
log wether a server successfully back-up or not and then will create a
report of it for month end etc.

I have the format of how I want it to work, but the thing is we
back-up every day (aren't we good! :) )

Now I can do it for one day, it is recreating it for the other 364
days of the year I am stuck with!!

Basically I have a flat table, listing the 5 servers with a failed
tick box and a comment box.

So every morning I want to open up the database, have that days log
appear (with the 5 servers listed and date displayed) tick which ones
failed and save it.

And that is it, then produce a simple report at the end of the month.

Is there a way of automating a new table everyday (I say table but it
can't be the answer doing a new table for every day?!)

So there we have it, I'll start trying a few things out but any ideas
are very welcome.

Thanks guys

Regards

Stewart

[Bernard Peek]

In message <41**************************@posting.google.com >, Stramec
<st***********@hotmail.com> writes

I have the format of how I want it to work, but the thing is we
back-up every day (aren't we good! :) )

Now I can do it for one day, it is recreating it for the other 364
days of the year I am stuck with!!

Basically I have a flat table, listing the 5 servers with a failed
tick box and a comment box.
If you are always going to have 5 servers then you can create a single
table with 5 YES/NO columns, one for each server, and one column for the
date and one for comments. Create a form, set its data-entry property to
Yes. Set the default value for the date column to now() -1 so that it
gets yesterday's date.

When the form opens it will display yesterday's date and an empty
check-box for each server.



So every morning I want to open up the database, have that days log
appear (with the 5 servers listed and date displayed) tick which ones
failed and save it.

And that is it, then produce a simple report at the end of the month.

Is there a way of automating a new table everyday (I say table but it
can't be the answer doing a new table for every day?!)

So there we have it, I'll start trying a few things out but any ideas
are very welcome.

Thanks guys

Regards

Stewart

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

[Pat]

Let me ask a few questions here first.
What means are you using to backup each server? Is there a log file for
that process or better is it a scheduled task?

If so, you probably want to work towards automation, but that will require
some VBA which might be more advanced than what your interested in.

Here's how I might tackle something like this. One table:
RecordID (autonumber)
ServerName (text)
BackupDate (date)
Completed (yes/no)

Write a record for each server and each date. How to automate the record
write will depend on how you are performing your backups.

Hope that gets you started,
Pat

"Stramec" <st***********@hotmail.com> wrote in message
news:41**************************@posting.google.c om...

Hi

I was wondering if anyone fancied throwing some ideas about for a new
task I've been set.

I'll say now I'm by no means an Access guru, so please bear that in
mind.

Basically I have been asked to create some form of database, that will
log wether a server successfully back-up or not and then will create a
report of it for month end etc.

I have the format of how I want it to work, but the thing is we
back-up every day (aren't we good! :) )

Now I can do it for one day, it is recreating it for the other 364
days of the year I am stuck with!!

Basically I have a flat table, listing the 5 servers with a failed
tick box and a comment box.

So every morning I want to open up the database, have that days log
appear (with the 5 servers listed and date displayed) tick which ones
failed and save it.

And that is it, then produce a simple report at the end of the month.

Is there a way of automating a new table everyday (I say table but it
can't be the answer doing a new table for every day?!)

So there we have it, I'll start trying a few things out but any ideas
are very welcome.

Thanks guys

Regards

Stewart

[Stewart McEwen]

thanks for the response guys.

I think I will steer clear of the automate VBA writing at this time. Company
likes it to be done manually just to make sure it all went ok.

I'll have a go at the form and go from there.

I assume writing a report from the form is a simple matter of a filter on
the yes/no field?

cheers

"Bernard Peek" <ba*@shrdlu.com> wrote in message
news:gW**************@shrdlu.com...

In message <41**************************@posting.google.com >, Stramec
<st***********@hotmail.com> writes

I have the format of how I want it to work, but the thing is we
back-up every day (aren't we good! :) )

Now I can do it for one day, it is recreating it for the other 364
days of the year I am stuck with!!

Basically I have a flat table, listing the 5 servers with a failed
tick box and a comment box.

If you are always going to have 5 servers then you can create a single
table with 5 YES/NO columns, one for each server, and one column for the
date and one for comments. Create a form, set its data-entry property to
Yes. Set the default value for the date column to now() -1 so that it gets
yesterday's date.

When the form opens it will display yesterday's date and an empty
check-box for each server.

So every morning I want to open up the database, have that days log
appear (with the 5 servers listed and date displayed) tick which ones
failed and save it.

And that is it, then produce a simple report at the end of the month.

Is there a way of automating a new table everyday (I say table but it
can't be the answer doing a new table for every day?!)

So there we have it, I'll start trying a few things out but any ideas
are very welcome.

Thanks guys

Regards

Stewart

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.