Backing Up and Restoring Databases in Microsoft SQL Server 2008 (E-Learning)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
Database
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Aug 25, 2009
Language:English
Audiences:IT Professional
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

This two-hour course provides you with the skills and knowledge required to plan and implement a backup strategy in SQL Server 2008. In this course, you will explore the different backup types and learn how to use them to formulate a backup strategy that meets your requirements. You will also learn how to create different types of backups and use the backup compression feature introduced in SQL Server 2008.

Topics covered in this course include:

Backup Strategies in Microsoft SQL Server 2008
Backing Up User Databases
Restoring User Databases
Implementing Database Snapshots
System Databases and Disaster Recovery

Objective: 

Understand backup strategies in SQL Server 2008.
Describe partial and copy-only backup.
Back up user databases.
Restore user databases.
Implement database snapshots.
Recover system databases..

Prerequisites: 

To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.

For more information on Backing Up and Restoring Databases in Microsoft SQL Server 2008 (E-Learning) please feel free to contact us online or call us at 416-513-1535.