Managing SQL Server 2000 Databases

Overview/Description
To guide students in configuring, performing, and automating routine administrative tasks

Target Audience
Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year’s experience administering SQL Server; at least one year’s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
140 Minutes

Objectives:

Managing SQL Server 2000 Databases

  • provide an overview of the SQL Server 2000 automation process.
  • describe how to configure SQL Server 2000 to automate tasks.
  • configure SQL Mail and SQLAgentMail.
  • create jobs and operators in SQL Server 2000 and be able to implement them.
  • create a multistep job and specify that an operator be notified.
  • explain how to develop a maintenance plan using the SQL Server 2000 Database Maintenance Plan Wizard.
  • create a maintenance plan for SQL Server 2000.
  • verify SQL Server 2000 automation and troubleshoot errors using error logs.
  • discuss the use of alerts, performance condition alerts, and a fail-safe operator in SQL Server 2000.
  • create alerts and user-defined error messages on SQL Server 2000.
  • create a user-defined alert on SQL Server 2000 using Enterprise Manager.


    • Course Number: 31552_eng