Understanding Databases
This section provides the information required to understand database concepts and understand how files, filegroups, and transactions logs are used in SQL Server.
In This Section
Topic  | 
Description  | 
|---|---|
Explains database concepts.  | 
|
Describes the system databases used in SQL Server.  | 
|
Explains file and filegroup concepts.  | 
|
Introduces the transaction log and the actions that it supports, and contains links to more advanced information about transaction logs.  | 
|
Describes database states.  | 
|
Describes file states.  |