User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
SQL Server 2005 MCTS 70-431 Series: Maintaining and Backing Up Databases
Product Code: sql407 Time: 3.0 hour(s) CEUs: Available

Summary:

This course explains how to use SQL Server 2005 to maintain and backup databases.

Objectives:

  • Identify the new features in SQL Server database maintenance
  • Perform a database backup
  • Identify the various backup types
  • Use the T-SQL BACKUP statement
  • Restore data from a backup
  • Create a database snapshot
  • Automate maintenance with job scheduling


Topics:

  • SQL Server Database Maintenance
  • Performing Database Backups
  • Backup Types
  • Using the T-SQL BACKUP Statement
  • Restoring Data from a Backup
  • Working with Database Snapshots
  • Automating Maintenance with Job Scheduling

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright � 2006 Webteks. All rights reserved.