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..
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!