Automatic Backup

[jl2886]

Is there a way to automatically create and save a backup database?

[Rabbit]

Depends on when and how you want to do it.

[jl2886]

Might you illucidate how? I don't know how I want to do it because I don't know what my options are?

[jl2886]

Hmm, maybe I want it to back up every day. and save to a different folder on the server

[Lysander]

Hmm, maybe I want it to back up every day. and save to a different folder on the server

This little script works for me, but probablly needs a lot of error checking

It copies my data to another drive, then renames the copy to the filename plus todays date.

This copies the database to another drive

copy z:\bissau\bissaudata.mdb e:\bissau\bissaudata.mdb
e:
cd ..
cd bissau
z:\bissau\renamedate bissaudata.mdb
 

This is the renamedate script

@echo off
:START
 
:: -----------------------------------
:: Usage - This check to make sure that there
:: is an argument For the script to use.
:: -----------------------------------
If %1!==! goto USAGE
Set MONTH=
Set DAY=
Set YEAR=
Set HOUR=
Set MIN=
Set MONTH=%DATE:~3,2%
Set DAY=%DATE:~0,2%
Set YEAR=%DATE:~6,4%
Ren %1 %YEAR%-%MONTH%-%DAY%-%1
 
 
Goto done
::
:: ------------------------ Sub routines ----------------------
::
 
:USAGE
Cls
echo.
echo.
echo ***** Error *****
echo.
echo.
echo Script did not run
echo.
echo.
echo.
echo Usage Syntax should be: %0 FileName
echo.
echo.
:done 
 

Please note this renamedate script was not written by me, I got it off of this forum but I forget who to give credit to.