Backing up SQL Server

[deepsix]

I know how to backup my sql server dbs, but I want to do it automatically... can I do that with program scheduler? if so, how?

thanks,

[laxbobber]

Make a maintainence plan for your database and one of the options in there is to do regular backups or both transaction logs and the database. Look in SEM for "maintainence plan"

[deepsix]

do i make that in enterprise manager?

[deepsix]

nevermind found it,

thanks !!