Backing Up SQL Server 2000 Databases

Overview/Description
To explain how to back up SQL Server databases

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
130 Minutes

Objectives:

Backing Up SQL Server 2000 Databases

  • explain why backups are necessary, when to perform backups, and what activities are restricted during backups.
  • describe backup options in SQL Server 2000 and use the BACKUP command.
  • create a permanent or temporary backup file that will contain the actual backup.
  • create a temporary backup file using Enterprise Manager.
  • perform a SQL Server backup using Enterprise Manager.
  • perform and schedule a full backup using Enterprise Manager.
  • plan a backup solution using one or more of the backup strategies provided by SQL Server 2000.
  • describe how to optimize SQL Server 2000 backups.


    • Course Number: 31556_eng