I'd suggest just using the Maintenance Plans. You're requirements are very simple and straight-forward, so you don't need a sophisticated script to take care of them. The Maintenance Plans will do exactly what you need with minimal work.
answered Sep 20 '12 at 11:54 AM
Grant Fritchey ♦♦
As Grant mentioned, Maintenance Plans will work just fine, however if you would prefer something codish, I would suggest checking out Ola Hallengren's Maintenance Solution. You can find the URL below.
Just another option.Hope this helps!
answered Sep 20 '12 at 12:10 PM
Maintenance plans are good & easy to start with they are actually SSIS package, you have the right tools there to do stuffs like backup, notification, older File delete and the list goes. Also, it alllows you to generate the scripts for the plans you created.... But again scripts provides you greater flexibility, but should be error free. :-)
answered Sep 20 '12 at 04:08 PM