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 2005.

In This Section

Topic Description

Database Basics

Explains database concepts.

System Databases

Describes the system databases used in SQL Server 2005.

Understanding Files and Filegroups

Explains file and filegroup concepts.

Introduction to Transaction Logs

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

Databases (Database Engine)

Help and Information

Getting SQL Server 2005 Assistance