Starting with this chapter, we begin an eleven chapter section on the various maintenance task options available when creating Maintenance Plans using the Wizard. In this chapter, we learn about the
Check Database Integrity task, what it does, and how to configure it. The purpose of the
Check Database Integrity task is to check the logical and physical integrity of all the objects in a database, looking for any corruption that could put your data at risk. The goal of the task is to try and identify small integrity problems early, so that they don't become bigger problems later.
With modern servers, data file corruption on storage devices is not as common as ...