Home » Course Catalog » Online Training Course Objectives and Outline
Microsoft 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:

Minimum 500MHz Processor; 128 MB RAM; Minimum display resolution 800x600; Windows 2000, XP, Vista, 7 or Mac OS X v10.4+; Internet Explorer 6.0+ or Firefox 3.0+ or Chrome 3.0+ or Safari 4.0+. 56K minimum connection; Adobe Flash Player 9.0+ or Windows Media Player 9.0+ for IE users who do not have Adobe Flash Player; JavaScript, popup windows and cookies enabled; Sound card with speakers or headphones strongly recommended.



Return To Top

Training Courses | e-Learning Edge | Training Course Certifications | Training Course Sign-up
Student Center | Learning Resources | Free Courses | Privacy Policy | Contact e-Learning Center

Hot Topics
IT Courses
MS Certs
Web Design
MS Office
Programming
Business
Networking
VS .NET
Personal
Full Catalog

Christian Website

Combo Packs... »

Save even more when you sign up for a combination package. Our BEST values EVER!

Read More

Monthly Specials - Big, Big Savings!! »

We always offer several special offers with savings from $50-$100 & more! Check out this month's special offers...

Read More

© 1999-2011 SK Max. All rights reserved.

General IT Web Design Microsoft Certs


Desktop Computing Business Skills Personal Skills


Combo Packages Business Videos

Articles

Features

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

Student Feedback

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information