Download the file attached to this article and extract the contents into a folder location on the server taking note of the location for future reference. These scripts are dependent on the machine name of the server, as well as the location where the scripts are stored. Ensure you are a domain administrator before continuing. Perform the following on the extracted files.
Right-click AutoBackup.bat and select Edit. AutoBackup.bat opens in Notepad.
Amend SET BACKUPNUMBERKEPT=x to be the number of backups you wish to keep and Save and Close the file.
Right-click BackupTAX.bat and select Edit. BackupTax.bat opens in Notepad.
Locate the line CALL AutoBackup.BAT <DBName> "<PATH>" <INSTANCE> and amend <DBName> to be the name of the Database. For example AETAX, SQLTAX, TAXSQL.
Change <PATH> to be the desired location of the backup. Ensure this is a local path with no spaces and that there is a trailing back-slash \ at the end.
Change <INSTANCE> to be the instance name, Save and close. The database details are updated.
For the Instance name, (local) is acceptable if installed to default instance.
If your practice runs Accountants Enterprise Practice Manager repeat steps 3 to 7 for BackupVPM.bat and use VPMSER or AEDB1 as the DBName for AEPM backups.
Double-click on AddScheduleTAX.bat. A command prompt window opens, runs the script and closes.
Double-click on AddScheduleVPM.bat. A command prompt window opens, runs the script and closes.