Differences

This shows you the differences between two versions of the page.

Link to this comparison view

control_-_automating_backups_in_sql_express [2019/01/27 11:28] (current)
Line 1: Line 1:
 +====== 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.
 +
 +
 +
 +<html><div style="margin-left: 20px;"> Download Link: [[http://s108199259.onlinehome.us/wiki/control/Files/Control%20-%20SQL%20Express%20Automated%20Backup%20ExpressMaint.zip|Control - SQL Express Automated Backup ExpressMaint]] </div></html>
 +  * Create an new task in Windows Task Scheduler with the following target path, be sure to set the schedule to your liking.
 +
 +
 +
 +<code>
 +"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
 +</code>
 +  * 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]] .
 +
 +
 +
 +[[http://www.sqldbatips.com/showarticle.asp?ID=27|Automating Database maintenance in SQL 2005 Express Edition Part I]]
 +
 +
 +
 +[[http://www.sqldbatips.com/showarticle.asp?ID=29|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|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
 +
 +
 +