SQL Server Express Automated Backup

SQL Server Express does not come with the SQL agent support which means there is no easy way to schedule backups of databases.

After some googling, a great article by Jasper Smith came up. He has built a wonderful stored procedure that backups all the databases on the instance and even produces a report for the backup.

Really nice feature of the script is that it will even allows you to manage how long the backups are kept for!

Read the original article