Maintenace Plan Best Practice

My question is recommendation for setting up maintenace plans that are safe and complete. What do you recommned I do for setting up a plan that backs up, and deletes old files older than 5 days. Should I do anything else and why?

thank you!

If you want to backup the database and delete the old backup files you can create a maintenance plan to backup dbs and another task to "Cleanup task" to remove old .bak files.........refer this link,

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

Thanxx

Deepak

|||

Thanks for the responce. I am pretty proficient at setting them up, however, I just am unsure about what is the best practice maintenace plan for my sql 2005 server as far as indexing and other cleanup type maintenance. Should I index and at what intervals, should I shrink the logs and databases and when and why?

Thanks!

sql