SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Creating Databases in the GUI

With the database options and storage structures covered, you're ready to create a database. In this chapter and the next two, you'll be creating and working with the Books database—the database you designed in Chapter 6, "ERD and Capacity Planning." In Exercise 8.1, you'll create the database that you'll use again in Chapter 9, "Data Types and Data Tables," for table creation and in Chapter 10, "Indexes and Views," for index creation. To ensure that the exercises in Chapters 9 and 10 work, make sure you follow the instructions in Exercise 8.1 exactly.

Creating a database in the GUI (graphical user interface) is a simple process. You can get to the GUI interface by right-clicking either the Databases node or an existing ...