schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nickCreate a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>