Auto Backup on SQL 2005 Express

Is there a way to setup an automatic function to backup the databases in SQL
2005 Express?On Feb 28, 2:43 pm, b...@.nascospg.com
<bhaynascospg...@.discussions.microsoft.com> wrote:
> Is there a way to setup an automatic function to backup the databases in S
QL
> 2005 Express?
You have to use the Windows scheduler to run the BACKUP DATABASE
command via SQLCMD.|||what would be the syntax, i have not performed this before or used the SQLCM
D?
thansk
"Tracy McKibben" wrote:

> On Feb 28, 2:43 pm, b...@.nascospg.com
> <bhaynascospg...@.discussions.microsoft.com> wrote:
> You have to use the Windows scheduler to run the BACKUP DATABASE
> command via SQLCMD.
>|||Automating Database maintenance in SQL 2005 Express Edition Part I
http://www.sqldbatips.com/showarticle.asp?ID=27
Automating Database maintenance in SQL 2005 Express Edition Part II
http://www.sqldbatips.com/showarticle.asp?ID=29
"bhay@.nascospg.com" <bhaynascospgcom@.discussions.microsoft.com> wrote in
message news:861F5C58-F9C0-4D5C-BEA2-727BF73E7BD8@.microsoft.com...[vbcol=seagreen]
> what would be the syntax, i have not performed this before or used the
> SQLCMD?
> thansk
>
> "Tracy McKibben" wrote:
>