Backup Schedule

Hi,
What is the easiest way, to schedule database backups in the express edition
2005 within the management studio express?
Thanks for your hint.
regards
PatrickHi Patrick
"Patrick D." wrote:
> Hi,
> What is the easiest way, to schedule database backups in the express edition
> 2005 within the management studio express?
> Thanks for your hint.
> regards
> Patrick
You can use the windows scheduler to run a SQLCMD session. You may want to
look at http://www.sqldbatips.com/displaycode.asp?ID=26 to do the backups.
John|||Hello,
If you want to schedule your backups in SQL Express, you could write a T-SQL
script using BACKUP DATABASE and then use
Windows Task Schedule to call SQLCmd to run the script on what schedule you
need the frequency.
Thanks
Hari
"Patrick D." <PatrickD@.discussions.microsoft.com> wrote in message
news:6344AF78-A132-44A9-BE5B-E17A83864AB0@.microsoft.com...
> Hi,
> What is the easiest way, to schedule database backups in the express
> edition
> 2005 within the management studio express?
> Thanks for your hint.
> regards
> Patrick|||http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx
Backing up Express
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
Andrew J. Kelly SQL MVP
"Patrick D." <PatrickD@.discussions.microsoft.com> wrote in message
news:6344AF78-A132-44A9-BE5B-E17A83864AB0@.microsoft.com...
> Hi,
> What is the easiest way, to schedule database backups in the express
> edition
> 2005 within the management studio express?
> Thanks for your hint.
> regards
> Patrick