How to schedule eMAM DB backup using Task scheduler?

How to schedule eMAM DB backup using Task scheduler?

Download the patch from the below FTP location
UserName : clients
Password : Emam@2025!Ftp#

Download Database_Auto_Backup_04AUG2021.zip  from the 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
  • Open the Execute.bat file in a text editor.
  • 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 the image below for reference.



  • Save and run the Execute.bat file.
  • Open the Execute.bat file in a text editor again.
  • Remove osql -S %svr% -d %dbname% -U %uname% -P %pwd% -i "proc_AutoBackupDatabases.sql"  -o "proc_AutoBackupDatabases.txt"  -n line from the script. PFA snap.



  • Save the file.
  • 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. 
  • Go to Trigger tab, Create a new trigger (when should the backup occur, Daily, Weekly, monthly or any specific time).
  • 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.
For any further assistance, please get in touch with eMAM Support at support@emamonline.com 

    • Related Articles

    • Health Check-up, Backup/Recovery & Patches/Upgrades for eMAM systems deployed on AWS Cloud

      Health Check-up In eMAM, you can monitor the statutes at various levels to ensure your system is functioning properly. Live Dashboard The Dashboard widget in the eMAM Director interface, gives you real time status of all the jobs submitted for ...

    • Bug Fixes eMAM 5.4

      Bug Fixes in eMAM 5.4 BUG ID DESCRIPTION 5.3.1_18NOV2021 11889 Storage DNA API change to handle "404 not found" in the response. 11899 Schedule metadata is not getting updated for PATCH api/v1/assets/{AssetId}/AssetMetadata 11708 PFR is not working ...

    • eMAM Workgroup 5.3

      eMAM Workgroup Server Specs Doc

    • Released eMAM Version 5.4 (April 2023)

      EMAM, Inc. is excited to announce the release of eMAM version 5.4! This new release includes several key features and enhancements to help you manage your media assets more efficiently than ever before. In addition to the key features, eMAM version ...

    • eMAM Cloud Platform - Production (eCP-Production)

      eCP-Production Deployment About this Guide This guide is intended for IT infrastructure architects, administrators, and IT professionals who are planning to deploy eMAM system (PAAS) on AWS Cloud. Overview eMAM Cloud Platform - Production ...