Automatic Backup

Users can create batch files to perform an automatic backup of their database. The sample batch files shown below create backups of the database specified in DB Setup. These specific backups will keep up to seven backups at one time and will overwrite, beginning with the oldest backup, as needed. Users can also configure Windows Scheduler to run the batch file automatically.

ClosedHow to Create a Automatic Backup Batch File
  1. Open Notepad.
  2. Copy and paste one of the batch files shown below into notepad.

    3. To Create a Batch File Locally

    DEL C:\FPOS5\DATA\Fusion7.bak
    REN C:\FPOS5\DATA\Fusion6.bak Fusion7.bak
    REN C:\FPOS5\DATA\Fusion5.bak Fusion6.bak
    REN C:\FPOS5\DATA\Fusion4.bak Fusion5.bak
    REN C:\FPOS5\DATA\Fusion3.bak Fusion4.bak
    REN C:\FPOS5\DATA\Fusion2.bak Fusion3.bak
    REN C:\FPOS5\DATA\Fusion1.bak Fusion2.bak
    REN C:\FPOS5\DATA\Fusion.bak Fusion1.bak
    C:\FPOS5\BIN\DBSETUP.exe /BACKUP C:\FPOS5\DATA\Fusion.bak

    To Create a Batch File on a Remote PC

    In order to create a batch file on a remote PC, you'll need to share the C:\ drive and grant the necessary users access to the share drive.

    DEL \\REMOTEPC\C\FPOS5\DATA\Fusion7.bak
    REN \\REMOTEPC\C\FPOS5\DATA\Fusion6.bak Fusion7.bak
    REN \\REMOTEPC\C\FPOS5\DATA\Fusion5.bak Fusion6.bak
    REN \\REMOTEPC\C\FPOS5\DATA\Fusion4.bak Fusion5.bak
    REN \\REMOTEPC\C\FPOS5\DATA\Fusion3.bak Fusion4.bak
    REN \\REMOTEPC\C\FPOS5\DATA\Fusion2.bak Fusion3.bak
    REN \\REMOTEPC\C\FPOS5\DATA\Fusion1.bak Fusion2.bak
    REN \\REMOTEPC\C\FPOS5\DATA\Fusion.bak Fusion1.bak
    C:\FPOS5\BIN\DBSETUP.exe /BACKUP \\REMOTEPC\C\FPOS5\DATA\Fusion.bak

  3. Save the file in Notepad with a .bat extension. For example, FPOSBackup.bat.
ClosedNotes

You can run the backup script manually by running the .bat file. You can also add the batch file to Windows Scheduler and configure it to run once a day (preferably, while the store is closed).

Open topic with navigation