SQL Server 2005 Tidbit 025

SQL Server 2005 Tidbit 025

Happy SQL Express User

This tidbit comes as an answer to a really good question asked at a recent TechNet Event:

“What if a Maintenance Plan fails at some point? Do I have the ability to restart the plan at a particular step?”

The answer to this is similar to the answer to the one in tidbit 28 – You really should consider plans as full sets of work.  If the plan fails at some point, you would probably want to launch the task separately, or create a job just to tackle what wasn’t otherwise completed.

Got an IT question?  Give me a comment, or contact me.