Schedule backups for SQL Server 2005 Express databasesPosted: October 27, 2008
I have to implement a solution to back up a SQL Server 2005 express database for a project. Here is a detailed step by step instruction to do this.
Create a stored prodedure in Master database to do the backup; create a .sql file to define which database to backup; use window scheduler (Scheduled Tasks ) to schedule the backup re-occurring times. Here is the link with the details: http://www.mssqltips.com/tip.asp?tip=1174