Does anybody have any advice/links for information on how to setup a maintenance plan for database(s) in SQL Server 2005?



Specifically, in the maintenance plan wizard.. Do I need to run the task labeled 'Check database integrity'? If and when do I need to run the shrink database task? etc.



I've found articles explaining what they are and what they do but not so many telling me yes I need to run it or no i dont. ;-)

Yup...TRUNCATE LOG is your friend