Database Backup

Write a Windows Service and do the following things:
1] Connect to database.
2] Create a SQL script for backing up the database.
3] Use a timer and in its Elapsed event, write code to execute the script.

:)

This can be done pretty easily just using a PowerShell script and using the Windows Scheduler to run the script every night (or week or whatever you want).

The script and documentation on how to set it up is all here: http://www.devio.at/index.php/automssqlbackup[^]

It does daily (differential) and weekly (full) backups, sends email notifications, and optionally zips the backup files if you want. That's what I use to back up all my databases every night, I haven't had any problems with it yet. Since it's just a script file, it's easy to add enhancements if you need anything additional (like adding SMTP credentials if needed)...

- Dave