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.


Overview

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.

Steps

  • Download ExpressMaint.exe utility to the [%Control Install Folder%]\Cyrious\Common\ folder.
    Download Link: 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.

Credits and Additional Resources

ExpressMaint.exe was developed by Jasper Smith. You can find additional information about this utility by visiting http://www.sqldbatips.com .

Automating Database maintenance in SQL 2005 Express Edition Part I
Automating Database maintenance in SQL 2005 Express Edition Part II
http://expressmaint.codeplex.com/
http://kb.verba.com/display/docs/Scheduling+backup+and+maintenance+for+SQL+Server+Express#SchedulingbackupandmaintenanceforSQLServerExpress-Configurationstepsrecurringdailyfulldatabasebackup

Version Information

  • Reported : 10/14/2009
  • Version(s): Control All

See Also