Is there a way to automatically create and save a backup database?
Automatic Backup
Collapse
X
-
This little script works for me, but probablly needs a lot of error checkingOriginally posted by jl2886Hmm, maybe I want it to back up every day. and save to a different folder on the server
It copies my data to another drive, then renames the copy to the filename plus todays date.
This copies the database to another drive
This is the renamedate scriptCode:copy z:\bissau\bissaudata.mdb e:\bissau\bissaudata.mdb e: cd .. cd bissau z:\bissau\renamedate bissaudata.mdb
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.Code:@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
Comment
Comment