This section provides the information required to understand database concepts and understand how files, filegroups, and transactions logs are used in SQL Server.
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.