From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Implement database integrity checks

Implement database integrity checks

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Implement database integrity checks

“

- Welcome back. This is Lesson 9.3, Implement database integrity checks. Before we get into configuring and implementing a database integrity maintenance task, let's first review what database integrity really is. Database integrity refers to the accuracy and consistency of data within a database, ensuring that the data remains intact. Database integrity also ensures that your data has not been corrupted, which can be caused through a number of reasons, including I/O subsystem failures, server crashes, or abrupt shutdowns. This is where the DBCC database integrity checks come in. DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database, and it does this by running the following operations. DBCC CHECKALLOC. This is run on the database, and it checks the consistency of disk space allocation structures. So, not only is database integrity on the data, but the structure of the database as well. So, DBCC CHECKTABLE, this checks the integrity, or…

Contents