Chapter 11. Creating and Managing Databases

By Paul Jensen and Ray Rankins

IN THIS CHAPTER

• What Makes Up a SQL Server Database?

• Data Storage in SQL Server

• Database Files

• Creating Databases

• Managing Databases

• Setting Database Options

The database is, of course, SQL Server's sole reason for existence. This chapter will examine what a database consists of, how to create one, and the ongoing management requirements of a database.