Scheduling SQL Server Backups

Modified on Wed, 04 Oct 2023 at 01:07 PM

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.
  • The utility must be used on a PC where ProCal is installed and configured
  • Extract the utility and place in C:\ProCal\Programs
  • 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.
  • Add your ProCal launch folder to the "Start in (optional)" field. This is usually "C:\ProCal\Programs"
  • 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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article