auto database backup scheduling with the change in the name of the backup file

[Siddharth]

actually i want to get the database backup automatically done at the midnight everyday. is there any method to do this(either by writting code or by using wizard)...one important thing i have to change the name of the backupfile everyday so that i can find out the file later. (preferably i want to append the month and date at the file name so that just by seeing the name of the file i can find which file was backedup and when). i am using MS SQL Server....MS SQL server provide ascheduling option in the TOOL menu but i am unable to change the name of the backup file automatically, it either appends to the already backedup file or overwrites it.

[pando]

not relevant, try some MS SQL Server forum
closing