josh.hill (11/21/2012)
A successful simple maint plan will consume between 40% and 80% of the trans log. A failure will max out the log. What other pieces of information do you need?
Don't rebuild all your indexes all the time. Rebuild just the ones that need rebuilding, there are several custom scripts that will do that for you, the maintenance plan task rebuilds everything .
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability