From the course: Microsoft SQL Server 2019 Essential Training
Join today to access over 24,800 courses taught by industry experts.
Database Console Commands (DBCC) - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Database Console Commands (DBCC)
- [Instructor] SQL Server has a number of built-in commands that'll check the structure of your databases and provide information that could be useful when troubleshooting problems. Collectively, they're called database console commands or DBCC commands. There are four categories of these commands, maintenance, miscellaneous, informational, and validation. If you scroll down on the documentation page, you're going to find each of those categories broken out into the individual commands that they contain. And, as you can see, there's a lot of 'em. When it comes to monitoring your database, and looking for potential corruption in the files, there's one that stands out as the most important, and it should definitely be in your toolbox. It's a database console command called CHECKDB. Let's go ahead and see how to use this in the Wide World Importers database. In order to run the console command, all you need is what's on line…
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.