Server back-up logging database

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

re: Server back-up logging database

In message <4101c478.0411020902.6b4d4996@posting.google.com >, Stramec
<stewartmcewen@hotmail.com> writes

[color=blue]
>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.[/color]

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.






[color=blue]
>
>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[/color]

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

re: Server back-up logging database

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" <stewartmcewen@hotmail.com> wrote in message
news:4101c478.0411020902.6b4d4996@posting.google.c om...[color=blue]
> 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[/color]

re: Server back-up logging database

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" <bap@shrdlu.com> wrote in message
news:gWtcbPXxq8hBFwyF@shrdlu.com...[color=blue]
> In message <4101c478.0411020902.6b4d4996@posting.google.com >, Stramec
> <stewartmcewen@hotmail.com> writes
>
>[color=green]
>>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.[/color]
>
> 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.
>
>
>
>
>
>
>[color=green]
>>
>>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[/color]
>
> --
> Bernard Peek
> London, UK. DBA, Manager, Trainer & Author. Will work for money.
>[/color]