Download the patch from the below FTP location
UserName : clients
Pwd : Clients_123
Download Database_Auto_Backup_04AUG2021.zip from folder SCRIPTS
Once the patch file is downloaded, follow the steps below :
- Extract the downloaded zip file and place the extracted folder in C:\Program Files\EmpressMedia folder and rename it to Database_Auto_Backup
- Set the database name (dbname), database user id (uname), and database password (pwd).
- dbname : emamdb
- uname: emam
- pwd: password
- Edit the value of the parameter "backuplocation" which is the destination location. It can be a local or network shared location. For example, If you need the emamdb backup inside D:\Backup\DB folder then the parameter should be given as set backuplocation='D:\Backup\DB\'. (Don't forget to add the \ at the end, if not, the DB backup will be created inside D:\Backup). See below image for reference.
![](https://support.emamsolutions.com/galleryDocuments/edbsn0a51ec331d8511464a10732d5c930536176832c235498d66e5333e9db3e727e87ceba056fda385ab92c675758f1228f8?inline=true)
- Open Windows Task Scheduler and create a new task.
- Provide name under the General tab and select 'Run whenever user is logged on or not' in Security options.
![](https://support.emamsolutions.com/galleryDocuments/edbsnb6ae205cb78f2470a0e33d9ec1307bc24d8a4a19fda2057a5112ac8575e5171247aee489718efdd0dba11eb48a9d9d2b?inline=true)
- Go to Trigger tab, Create a new trigger (when should the backup occur, Daily, Weekly, monthly or any specific time).
![](https://support.emamsolutions.com/galleryDocuments/edbsn3f83a1e0bc171c7836058fdb9918dd1833e1a244215622dee34f4a4c28335f1d3ddd2dc382f178e857af7c314dff3b3c?inline=true)
- Go to Actions tab, Create new Action
- Action -> Select a program
- Program/Script -> Browse the location where Exectue.bat file exist. e.g: "C:\Program Files\Empress Media\Database_Auto_Backup\Execute.bat" (Do not remove the double quotes)
- Start in -> Paste the location were Execute.bat exist (Don't add Execute.bat). e.g: C:\Program Files\Empress Media\Database_Auto_Backup\
- Hit OK, the Task will be created. You can test the script by hitting the 'Run' option.