Devices, Databases, and Drives

The chapters in this part tell you how to manage devices, databases, transaction logs, and drives.

Chapter 5, Managing Devices, describes devices, the operating system files used to store databases, transaction logs, and their backups. Before you can create a new database you must create the device(s) the database will be stored on. This chapter tells you how to create and manage devices.

Chapter 6, Managing Databases, tells you how to create and manage databases and their transaction logs. (A transaction log is a storage area reserved by SQL Server to keep track of transactions made to the database)..

Chapter 7, Managing Drives, helps you improve SQL Server performance by showing you how to efficiently manage the placement of data on storage devices.