From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 25,300 courses taught by industry experts.
Identify database corruption - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Identify database corruption
- [Narrator] Advances in computing hardware have come a long way over the years, but they're still limited by the undisputed fact that machines simply wear out, and that bugs can creep into the software that drives them. Data corruption can occur on any computer, including those that power SQL Server. So it's important to have a plan in place to combat corruption when, not if, it occurs. Let's start by understanding what exactly corruption is. When a computer writes data to a disk drive, it's simply flipping magnetic bits from zero to one and back again. It's the sequence of ones and zeros that is interpreted by the computer, and gives meaning to the data that's being stored. When those bits don't get written in the proper sequence, or otherwise changed from their intended sequence, then data corruption is said to have occurred. Think of a scratch on an old audio record. If the scratch is deep enough or at the right angle,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.