how to automate file back-up?

  • Thread starter Thread starter tradmusic
  • Start date Start date
T

tradmusic

Hi.

Is there a facilty, within Windows, to automatically back up particular
files to a specified location?

We would like to automatically back up an Access database, lets say daily,
to another location on our system, even a couple of locations to be
"super-safe".

Any advice would be greatly appreciated. Thanks.
Nathon.
www.tradmusic.com
 
tradmusic said:
Hi.

Is there a facilty, within Windows, to automatically back up particular
files to a specified location?

We would like to automatically back up an Access database, lets say daily,
to another location on our system, even a couple of locations to be
"super-safe".

Any advice would be greatly appreciated. Thanks.
Nathon.
www.tradmusic.com
Click to expand...

As long as you (or nobody else via lan access) is using this Access
file, you can copy it elsewhere. Make yourself a small command file,
which copies the file from where it is to where you want it to go, e.g.

copy c:\data\access_file_name.mdb \\fileserver\backup\*.*
copy c:\data\access_file_name.mdb \\someother_file_server\backup\*.*
...
...
etc.

save the file as "access_backup.cmd".

Use the Windows scheduler to schedule running this command file at
whatever intervals you want.

You could use Windows backup program to do this, including scheduling,
but then you'd end up with the copy of the file in some other format.
Since you intention is to simply backup this file, then easiest to just
do that.
 
Thanks Rob,

Pretty new to .cmd writing...do I just create this in Notepad, then save as
a .cmd?
Does it matter where the .cmd is stored on my C?

Thanks for your help.
Nathon
www.tradmusic.com
 
Yes, create in Notepad, with a .cmd extension. Doesn't matter where it
goes. I put all the commands and little programs I write myself or get
elsewhere into a folder called c:\bin.

You have to realise I made up the file names in the example below :-)

to get help on the commands available, type "help /?" on a command
prompt box. To get help on any command, theyp "help commandname" where
command name is the command name. Or lookup that command in the Windows
help.
 
Hi,

Yes, I did realise that they were example directory / file names, but thank
you for not assuming that I knew! : )

Exactly what I was looking for, thanks Rob.

Regards
nathon
www.tradmusic.com
 
Back
Top