Home Forums Discussions General Discussion Amazing automator is not automating

So, I'm curious, in creating the backups, are you just automating ACBackup? or some other application? What routine is your script calling? Can't wait to dissect that.

The batch file is simply a text file with a series of commands which are executed by command.exe. A batch file .bat or a command file .cmd are used a lot for copying one folder to another folder via xcopy or copy with some variables called swithches.

The batch file has nothing to do with the AC program itself. It simply copies a folder and all of its contents to another location:

xcopy "C:\Program Files\Amazing Charts\" "\\server\acbackup\" /S /Y /H

For SQL you would need something like

Net Stop "SQL Server (AMAZINGCHARTS)" before the copy command line and

Net Start "SQL Server (AMAZINGCHARTS)" after the copy line
Pause

Write the code for time and date stamp is a bit more complicated and write maintenace code is as well.

But, all of the code is on the Internet.