Installing, Configuring, and Upgrading SQL Server 2000

Overview/Description
To describe how to install, configure, and upgrade SQL Server

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
Familiarity with a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition, at least one year's experience administering SQL Server, and 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, multiple installations of SQL Server 2000

Expected Duration
125 Minutes

Objectives:

Installing, Configuring, and Upgrading SQL Server 2000

  • discuss the hardware requirements and installation options for SQL Server 2000.
  • perform an installation of SQL Server 2000 using the SQL Server setup program.
  • perform a typical installation of SQL Server 2000.
  • locate and describe the directories, tools, and files of SQL Server 2000.
  • start, stop, or pause SQL Server, register servers, create server groups, and connect to SQL Server.
  • install and troubleshoot a SQL Server 2000 installation.
  • upgrade SQL Server 6.5 databases to SQL Server 2000 databases.
  • upgrade from SQL Server 7.0 to SQL Server 2000.
  • upgrade SQL Server 7.0 databases to SQL Server 2000.


    • Course Number: 31489_eng