ms sql maintenance plan
this is my current set up for a sql maintenance plan (i use the plan wizard):
backup (full backup)
optimize (rebuild indexes, update statistics, shrink database, check integrity)
cleanup (delete expired backups)
on different days if possible