Chapter 6 -- Creating and Configuring User Databases

3 4

Chapter 6

About This Chapter

This chapter prepares you to create and configure user databases. The chapter begins with learning the mechanics of creating a user database, using either SQL Server Enterprise Manager or Transact-SQL statements in SQL Query Analyzer. Next you learn about the various database options that you can set and how to set them, either at the time of creation or after the database is in production. Next you learn about manual and automatic methods of managing the size of user databases, including both data and transaction log files. Finally you learn how to optimize your disk subsystem by placing data and transaction log files on multiple disks, using a combination of RAID, filegroups, and multiple disks. After you have completed these tasks, you will be ready to begin loading data into your SQL Server 2000 installation.

Before You Begin

To complete this chapter, you must have

• A computer that meets or exceeds the minimum hardware requirements listed in Table 2.1, "Hardware Requirements," in Lesson 1 of Chapter 2.
• Microsoft Windows 2000 Server running on your computer on an NTFS partition.
• A computer with a NetBIOS name of SelfPacedCPU, configured as a domain controller in the SelfPacedSQL.MSFT domain.
• Installed a default instance and at least one named instance of SQL Server 2000 (see Chapter 2).