Microsoft® SQL Server 2005 Unleashed

Chapter 18. Creating and Managing Databases

IN THIS CHAPTER

• What’s New in Creating and Managing Databases

• Data Storage in SQL Server

• Database Files

• Creating Databases

• Setting Database Options

• Managing Databases

A database is a collection of tables and related objects that helps protect and organize data. It must exist before you can create all database objects, including tables, indexes, and stored procedures. This chapter focuses on how to create a sound database that can house database objects and how to manage the database after the objects are created. The creation and management of the various database objects is discussed in the remaining chapters in Part IV, “SQL Server Database Administration.”

Note

It is important to remember that SQL Server actually ...