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