Go back

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

Got a project? Let's work together

Compsoft is a remote working company except for Thursdays when we work together from the Alton Maltings in Alton, Hampshire (UK). Our registered address is detailed below. We'd be delighted to have either a virtual chat with you or to make arrangements to meet in person.