I am new to Sqlserver 2005 and I have created the maintenance plan where about 10 databases are being backedup using the maintenance plan described in the following link: http://www.mssqltips.com/tip.asp?tip=1094 However I have not used all the steps described in the plan as I am not sure what would be the significance of each plan. In my plan I have Back Up Database Task and Maintenance Cleanup Task. What are the other tasks I need to include in the maintenance plan? If anyone can send me some advice that would be a big help.
Regards
Chitra