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



Database Basics

Explains database concepts.

System Databases

Describes the system databases used in SQL Server.

Understanding Files and Filegroups

Explains file and filegroup concepts.

Transaction Log Overview

Introduces the transaction log and the actions that it supports, and contains links to more advanced information about transaction logs.

Database States

Describes database states.

File States

Describes file states.

See Also

Other Resources