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.
To complete this chapter, you must have