Automating Backups in SQL Server 2005 Express Edition

NOTE: This original documentation of this utility is no longer online. You will need to utilize other resources online, try google.com for assistance with this utility.

Microsoft SQL Server Express Edition does not include a built-in backup utility like the full versions of SQL Server offer within maintenance plans. However, this does not mean that you can not automate the backup process with a few small steps. This tutorial assumes that you have a working knowledge of SQL Server and basic windows administrative tasks.

  • Download ExpressMaint.exe utility to the [%Control Install Folder%]\Cyrious\Common\ folder.

Download Link: [[http://s108199259.onlinehome.us/wiki/control/Files/Control%20-%20SQL%20Express%20Automated%20Backup%20ExpressMaint.zip|Control - SQL Express Automated Backup ExpressMaint]]

  • Create an new task in Windows Task Scheduler with the following target path, be sure to set the schedule to your liking.
"C:\Program Files\Cyrious\Common\ExpressMaint.exe" -S (local)\CYRIOUS -D ALL_USER -T DB -R C:\Progra~1\Cyrious\Control\Backups -RU WEEKS -RV 1 -B C:\Progra~1\Cyrious\Control\Backups -BU DAYS -BV 1 -V -C
  • This task will run the backup utility ExpressMaint.exe with the parameters specified in the target above. This will perform a FULL backup all User databases and place them in the folder specified. A report will be created within the folder with a summary of the backup success. This script will automatically remove any backups and reports over 1 week old in age.
  • Reported : 10/14/2009
  • Version(s): Control All
You could leave a comment if you were logged in.