From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Database Console Commands (DBCC)

Database Console Commands (DBCC) - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial Buy for my team

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…

Contents