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.

• 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.

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

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