Using ExpressMaint to Backup SQL Server Express 2005 Databases

You can automatically back up all user databases in your SQL Server Express 2005 install using either a stored procedure or command line program combined with windows task scheduler. ExpressMaint was written to bring some of the backup functionality from SQL Server 2000 to SQL Server Express 2005 and seems to be pretty easy to use based on the instructions at sqldbatips.com.

Combining regular backups using ExpressMaint with some shadow copying of the data files provides a fair bit of redundacy in the event of hardware failure, database corruption etc..

One thought on “Using ExpressMaint to Backup SQL Server Express 2005 Databases

  1. Hi,

    I have been using expressmaint to automatically backup SQL 2005 and 2008 express databases. I like the progrom. However, ever since microsoft has introduced file streaming, this utility does not seem to backup the FS file/folder.

    Can anyone help?

    Many thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>