Managing Database Integrity
SQL Server 2016
| Intermediate
- 10 Videos | 53m
- Includes Assessment
- Earns a Badge
Managing database integrity by ensuring objects are structurally sound and properly allocated is an important aspect of database administration. Explore database consistency checks and how to identify and recover from database corruption.
WHAT YOU WILL LEARN
-
describe the purpose of the Database Consistency Checkeruse the Database Consistency Checker in SQL Server Management Studiouse the catalog view to see information about progress and current phase of executiondescribe the types of consistency checks appropriate for databasesperform consistency checks on indexes
-
recognize common consistency check errors and their resolutionsrecognize possible causes of database corruptiondetect corruption in a SQL Server databaserecover from database corruptionuse SQL Server 2016 tools to ensure database consistency
IN THIS COURSE
-
1.Database Consistency Checker4m 11sUP NEXT
-
2.Using Database Consistency Checker in SSMS4m 56s
-
3.Viewing Progress Reports for DBCC Commands4m 53s
-
4.Performing Checks on Databases8m 34s
-
5.Performing Checks on Indexes6m 10s
-
6.Consistency Check Errors4m 32s
-
7.Database Corruption4m 25s
-
8.Identifying Database Corruption6m 4s
-
9.Recovering from Database Corruption3m 52s
-
10.Exercise: Ensuring Database Consistency5m 24s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.