Chapter 3 -- Preparing to Use SQL Server 2000

3 4

Chapter 3

About This Chapter

This chapter prepares you to use instances of SQL Server 2000 after an installation. You will begin with reviewing the results of the installation of SQL Server 2000. Next, you learn about controlling (starting, stopping, pausing, and modifying) the SQL Server services. Finally, you learn to work with the main graphical and command-prompt administration tools. After you have completed these tasks, you will be ready to begin administering SQL Server 2000.

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 and at least one named instance of SQL Server 2000 (see Chapter 2).