Sql Server - Schedualed Backup

[DroopyA]

I need to schedual a regular backup for SQLServer and / or MSDE.... I know how to do it manually but I'm trying to do it programmably.

I can set up a Schedualed Task in windows but I'd rather not... I know for sure I can go into Enterprise Manager and set up a schedualed Backup... I assume this sets up a Task in Windows.

Ideally, I'd like my code to run a SQL procedure that sets up a schedualed task. This would trigger SQL to do it's thing to set up the task in windows appropriatly.

Does anyone know how to do that? I've searched google and nothing has come up as far as schedualing goes... it's all just one time backup code.

Does anyone know how to do this, or know of anything that I might search for to help turn up better results?

Sorry, I know I can't spell worth shit...

[Fruitpastles]

http://www.noupe.com/php/10-ways-to-auto matically-manually-backup-mysql-database .html

Using PHP and cron jobs is a good way to go. You could use the method described in that article to backup your database to an XML file and have your sql check too. Then set the script to run at an appropriate interval using Crom Jobs.

[elbekko]

http://www.microsoft.com/sqlserver/2008/
en/us/manageability.aspx
Look at the Automate bit.

I'm sure you'll be able to find some more information from there on out.