Profile

e-Catalog

Contact

Search

Cart

Microsoft SQL Server 2000 Database Administration III: Backing Up SQL Server 2000 Databases

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	5 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

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

Course Aim

This learning path describes in detail the advanced administration of Microsoft SQL Server 2000.

Learning Objectives

To explain how to back up SQL Server databases

Topics Covered

The SQL Server 2000 backup Preventing a disaster in SQL Server 2000 Backing up in SQL Server 2000 Creating permanent and temporary backup files Creating a temporary backup file in SQL Server 2000 Backup methods Implementing a backup strategy Performing a full backup in SQL Server 2000 Planning a backup strategy SQL Server 2000 backup strategies Optimizing SQL Server 2000 backups