Troubleshooting SSMS Maintenance Plans
Video References
These additional references will help you take what you've learned in this SQL Server Video to the next step.
Book References
Microsoft SQL Server 2005 Administrator's Pocket Consultant
Relevance: Chapter 15 includes some insights into creating Maintenance plans, and also provides some coverage on how to interpret log file results work with the Log File Viewer.
Links / References
Microsoft Help and Support [link]
Relevance: This KB article (953118 covers what kinds of changes you can make within your SQL Server Agent Jobs and what happens to them when you modify your Maintenance Plan. (i.e. your saved changes will be lost)
Microsoft Help and Support [link]
Relevance: Here are a number of KB articles dealing with specific problems that you might encounter while troubleshooting SQL Server 2005
and 2008 maintenance plans
923355 - Backup Failed for 'Computer Name\InstanceName' and 'sysft_FullTextCatalog' problems
938085 - Cleanup tasks not deleting reports




