From the course: SQL Server 2022 Administration

Unlock this course with a free trial

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

Setup database files

Setup database files - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Setup database files

“

So every SQL Server database you create on an instance is really just a collection of files that exist on a drive somewhere. And the different files serve some different purposes, but essentially that's all it is. And so we want to take a look at what these files are and understand how SQL Server uses them in order to create databases. So I'm just, kind of, going to flip over to this WideWorldImporters database, which, again, is a sample database you can download from Microsoft. I'll right click it and I'll hit "Properties." And when this comes up, I will click the "Files" page. Okay. Now here, there are a lot of different file types, not a lot, there's four on this particular database, and what we have is, for primary data, we have a file type that's called ROWS Data. For UserData, we have another one that's ROWS Data. Then we see this InMemo file, which is FILESTREAM Data. And finally, we see a LOG file. Okay. Now, couple different things. A: Every database will have a data file…

Contents