I understand that you can set up a backup task using windows scheduler, but how, I need help with the syntax.

Looking at windows scheduler, Windows 7

click create task (all the other options within windows scheduler are self explanatory)

on the 'actions' tab click 'new'

there is a 'program/script' files (with a browse button next to it)

I entered the following - path to sqlcmd

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE"

and then within the add argument (optional) field the following

backup database database_name to disk = 'c:\database_name.bak'

this did not work, i expect i need to add a login or something....so can anyone help with the syntax required as im not familiar with sqlcmd