Automatic Backup

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jl2886
    New Member
    • Mar 2007
    • 83

    #1

    Automatic Backup

    Is there a way to automatically create and save a backup database?
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Depends on when and how you want to do it.

    Comment

    • jl2886
      New Member
      • Mar 2007
      • 83

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

      Comment

      • jl2886
        New Member
        • Mar 2007
        • 83

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

        Comment

        • Lysander
          Recognized Expert Contributor
          • Apr 2007
          • 344

          #5
          Originally posted by jl2886
          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
          Code:
          copy z:\bissau\bissaudata.mdb e:\bissau\bissaudata.mdb
          e:
          cd ..
          cd bissau
          z:\bissau\renamedate bissaudata.mdb
          This is the renamedate script
          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
          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.

          Comment

          Working...