From the course: Microsoft SQL Server 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Explore the role of system databases - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Explore the role of system databases
- [Instructor] In Management Studio, at the top of the Databases folder are the System Databases. These four databases, master, model, msdb, and tempdb, are required for the server to operate. Now, while it's okay to dig into them with select queries to see what they contain, at no point should you attempt to modify their contents. So don't alter their tables, don't add or delete any records. SQL Server has a number of built-in dynamic management views, console commands, and systems store procedures that will allow you to safely interact with these databases. So it's likely that you won't need to access them directly anyway. But if you're curious as to what they do, let's take a quick tour. The master database contains tables and views that are essential to the functionality of the entire server. These tables store information about login accounts, system settings, and information about all of the user databases that the server contains. If you delete the master database or if it…
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.