Profile

e-Catalog

Contact

Search

Cart

Microsoft SQL Server 7.0: Restoring and Managing 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 restore and manage SQL Server 7.0 data

Learning Objectives

Detail the data recovery process in SQL Server 7.0. Show how to perform a full, differential, transaction log, and file/filegroup restore. Explain how to restore the master and other system databases. Describe how to set up a standby server. Troubleshoot and resolve some common problems with the backup and restore process. Show how to create a linked server and configure secure login mappings between linked servers. Detail how to execute distributed queries over linked servers.

Topics Covered

Restoring data - Database recovery - Restore strategies - Hands-on: Restoring a database - Hands-on: Restoring from a transaction log Standby servers and troubleshooting - Standby servers - Hands-on: Implementing a standby server - Troubleshooting Linked servers and distributed data - Linked servers - Creating a linked server - Hands-on: Configuring a linked server - Distributed queries