Backing Up SQL 2005 Express Databases

Two of the features missing from SQL 2005 Express is support for SSIS and SQL Agent. Without these two features you are unable to setup maintenance plans to backup your SQL databases to disk. Luckily a user at webhostautomation.com developed a script that you can call from a batch file.

The script can be viewed here http://forums.webhostautomation.com/showthread.php?t=17198 .

Save the script as a .sql file and then use Windows Task Scheduler to call a batch file with the following text:

sqlcmd -S . -i “C:\Backup_All_Databases.sql”