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 SQL
> 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 SQLCMD?
thansk
"Tracy McKibben" wrote:
> 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 SQL
> > 2005 Express?
> 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...
> what would be the syntax, i have not performed this before or used the
> SQLCMD?
> thansk
>
> "Tracy McKibben" wrote:
>> 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 SQL
>> > 2005 Express?
>> You have to use the Windows scheduler to run the BACKUP DATABASE
>> command via SQLCMD.
>>