Chapter 12 -- Performing Administrative Tasks

3 4

Chapter 12

About This Chapter

This chapter prepares you to perform a variety of administrative tasks. You will learn about performing configuration, setup, and maintenance tasks related to SQL Server 2000. These tasks include configuring the Windows operating system, the SQL Server service, the SQL Server Agent services, and SQL Server Enterprise Manager. You also learn to set up additional features of SQL Server 2000, including SQLAgentMail, SQL Mail, linked servers, and XML support. Finally, you learn about performing periodic maintenance tasks.

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) .


MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
ISBN: N/A
EAN: N/A
Year: 2001
Pages: 126

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net