From the course: Microsoft SQL Server 2016 Essential Training
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Advanced database configuration options - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Advanced database configuration options
- [Instructor] In this section, we're going to look at some of the options we have when configuring a database. So I'll take one of the databases created in the previous section, I'll right-click on it and go to Properties, and we see a pretty extensive Properties window. There's quite a number of pages, we'll take about each one of these. On the General page, we see nothing that we can change, but we're just given some diagnostic information, such as when the database was created, when was it last backed up, things like that. The next one, Files, we'll see the two files that every database has by default, and if we like, we can add more files. I'm going to do that in a minute, but first I'd like to look at the next page, which is Filegroups. Every database has one Filegroup called PRIMARY, and for many databases that is sufficient. If you'd like to add an additional filegroup you can by clicking on "Add Filegroup." You'll have give it a name, I'll call mine "Secondary." Then was have…
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.