Scheduling SQL Server Backups

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.