It is important to ensure that your SQL Database is regularly backed up. SQL Server Express does not have a native tool for automating backups, so to create scheduled please follow this guide.


  • Download the Transmille SQL Server Utility that is attached to this article.
  • Save the utility in a local location - recommended is C:\ProCal\Transmille Utilities (create the folder if it does not already exist.
  • Run the utility and select 'Configure Backup Location'.
  • Set the location where you would like backups to be stored using the file browser.
  • Press 'OK' and close the utility.
  • Open Windows Task Scheduler.
  • Select 'create task' from the actions menu.
  • Name the task and give it a description.
  • Choose whether to run only if the user is logged on, or whether the user is logged on or not (recommended).
  • Check 'run with highest privileges'.
  • Configure for the operating system that you are running on using the drop down menu.
  • Select the 'Triggers' tab.
  • Select 'new'.
  • Create the trigger for your backup process. A daily backup is recommended as a minimum:
  • Select 'OK' once your desired schedule has been created.
  • Select the 'Actions' tab.
  • Select 'new'.
  • Set the 'Action' drop down to 'Start a program'.
  • Enter the path to your Transmille Server Utility (default name of file is 'SQL Server Status.exe') or browse to the file location.
  • Add the text '/alltasks' in the 'Add Argument (optional) box.
  • Select 'OK'.
  • Select the 'Conditions' Tab.
  • Replicate the settings in this tab as per the below screenshot:
  • Select the 'Settings' tab.
  • Either use recommended settings (see screenshot below) or configure according to your system requirements and IT Policies:
  • Select 'OK'.

  • Your backup task has now been created.