© Peter A. Carter 2019
Peter A. CarterPro SQL Server 2019 Administrationhttps://doi.org/10.1007/978-1-4842-5089-1_6

6. Database Configuration

Peter A. Carter
(1)
SOUTHAMPTON, UK
 
Within a database, data is stored in one or more data files. These files are grouped into logical containers called filegroups. Every database also has at least one log file. Log files sit outside of filegroup containers and do not follow the same rules as data files. This chapter begins by discussing filegroup strategies that database administrators (DBAs) can adopt before it looks at how DBAs can maintain data and log files.

Data Storage

Before considering which filegroup strategies to adopt, it is important that you understand how SQL Server stores data. The diagram in ...

Get Pro SQL Server 2019 Administration: A Guide for the Modern DBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.