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
 +
 +
 +