Taking Automatic Backup Of sql server database

[saurabhsingh]

Hi
I need to take automatic backup of my sqlserver2005 database per day.
And I don't want to replace old backup,a new backup should be made per
day.

Thanks in advance

[ShaluGoogle]

U can do it through any application na? Or u want the SQl Server itself to take backup automatically?

[saurabhsingh]

Yes I wanted SQL Server itself take backups automatically..
And i have successfully executed this task using a stored procedure
and running this procedure using windows scheduled task.

by the way Thanks for your reply..

[mukeshrasm]

Hi I also need to take the database backup so can you please show me your stored procedure