Differences
This shows you the differences between two versions of the page.
— |
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. | ||
+ | |||
+ | |||
+ | |||
+ | < | ||
+ | * Create an new task in Windows Task Scheduler with the following target path, be sure to set the schedule to your liking. | ||
+ | |||
+ | |||
+ | |||
+ | < | ||
+ | " | ||
+ | </ | ||
+ | * 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:// | ||
+ | |||
+ | |||
+ | |||
+ | [[http:// | ||
+ | |||
+ | |||
+ | |||
+ | [[http:// | ||
+ | |||
+ | |||
+ | |||
+ | [[http:// | ||
+ | |||
+ | |||
+ | |||
+ | [[http:// | ||
+ | |||
+ | |||
+ | |||
+ | ===== Version Information ===== | ||
+ | * Reported : 10/14/2009 | ||
+ | * Version(s): Control All | ||
+ | |||
+ | |||
+ | |||