Automating a database backup

If you are using SQL Server Express, which doesn’t have support for automatic backups, you can use FinJinni to run a SQL database backup on a schedule. Setup a scheduled task with these parameters:

/ex “extract-name”  /dbackup “output file name”

“extract-name” identifies the database and the output file name specifies the path and name of the backup file. Using the “/dbackup” option will perform the database backup instead of an extract.