Profile

e-Catalog

Contact

Search

Cart

Microsoft SQL Server 7.0: Backing Up Data

Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To enable students to determine and configure an appropriate backup strategy and prevent data loss using SQL Server 7.0

Learning Objectives

Discuss SQL Server 7.0?s data availability solutions. Identify the SQL Server 7.0 tools, utilities, and strategies for importing, exporting, and distributing data and preventing data loss. Explain how backups work in SQL Server 7.0. Choose the appropriate backup strategy for specific scenarios. Show how to create a backup device. Describe and show how to perform a full, differential, transaction log, and file/filegroup backup. Assess whether to use a standby server or server clustering.

Topics Covered

Backups and data availability - Planning data availability - Preventing data loss - Hands-on: Ensuring data availability Preparing a backup strategy - Preparing a backup - Planning a strategy - Backup devices Implementing backups - Full database backups - Other backup strategies - Hands-on: Performing a backup