Restoring SQL Server 2000 Databases

This course is included in our On-demand training solution.


To describe the process involved in restoring 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


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

105 min.

Course Objectives

Restoring SQL Server 2000 Databases

  • explain how to perform prerestore tasks, verify backups, and describe the SQL Server data recovery process.
  • use the RESTORE statement and the different restore options.
  • restore damaged system databases.
  • rebuild the master database and attach a user database.
  • restore a database from full, transaction log, differential, and file or filegroup backups.
  • restore a full backup using Enterprise Manager.
  • perform a point-in-time transaction log backup using Query Analyzer.