O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Check Database Integrity Task

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.

An Overview of the Check Database Integrity Task

With modern servers, data file corruption on storage devices is not as common as ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required