Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to schedule a backup Micros 3700.

Status
Not open for further replies.

BumblingIT

IS-IT--Management
May 31, 2017
4
GB
Thanks in advance.
Micros 3700 V4.3.6.1200
I have just started in a business with Opera and Micros POS 3700, I am looking after the backend functions as a side job to my main job.
I have installed Acronis backup on the old WS2003 box running Micros and run a few backups per day. These was no backup software, before I started, test restores work :).
I am wanting to move this to a VM in the long-term.
I have found a .bat file called FullDbBackup.bat the command line used is
dm -uid 2000 -pwd -q -b -v
I gather the -uid is the 2000 user.
But what I am wanting to do is run the backup with similar settings to the database manager backup which is
Backup database
Validate databse
Backup password – keys
I want both the database and keys backup path to be the same location (this OK?)
\\sa-02\BackupFiles\Micros\DB-Backups
With an option for it keeping say 30 backup archives.
I cannot find anything online with the switches for the dm.exe function.
Is this possible, or can I achieve at least part of this above from a .bat file?
Is it best to run this from within the POS scheduling function or from windows scheduler?
 
Got a solution with the help of
The backup location settings that the command
dm -uid <user defined> -pwd <user defined> -b -k -v -q
use are set by the GUI of Database Manager

The .bat file I used is

@echo off
cls
echo Please wait while the database is backed up.......
cd D:\micros\common\bin

rem ***Classic Security
rem dm -uid 2017 -b -k -v -q
rem where 2017 is the login code


rem ***Complex Security***
rem dm -uid <user defined> -pwd <user defined> -b -k -v -q
rem where 88888888 is the user id and password

dm -uid 88888888 -pwd 88888888 -b -k -v -q

exit

The .bat file runs every 2 hours.

I have a monitor for any files in the backup folder with .bad in there name to produce an alert if there are more than 5 files with .bad in the name.

Hope this helps anyone else.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top