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

This entry was written by resinblade , posted on Thursday June 02 2011at 01:06 pm , filed under IT . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

Leave a Reply

You must be logged in to post a comment.