Chapter 11. Creating and Managing Databases

By Paul Jensen and Ray Rankins


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

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features