Automate Backup of SQL Express Databases
It's a fact that no integration services and SQL agent available in SQL Express products, but it's a must to backup SQL Express databases in a timely basis. There is a very useful article describing how to do it with TSQL and Windows Schedule Tasks.
- Backup DB - Prepare a SQL script to backup database (Someone suggest using the Generate Script function in Management Studio from the Backup operation screen too)
- Housekeeping - Prepare a VBScript file to remove old backup files
- Execution - Prepare a batch file to execute #1 and #2
- Scheduling - Put #3 in Windows Task Scheduler
URL: http://www.mssqltips.com/tip.asp?tip=1486