Skip to main content

Module 12: Backup and Recovery

In this module, you will learn the following:

  • Backup and recovery methods available in Oracle and SQL Server 2008
  • Types of failure
  • Types of recovery
  • Formulating backup and recovery strategies

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download

Length: 21 Minutes 31 seconds

Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.

Module 12: Demo 1

In this demonstration you will learn to:

  • Locate the Recovery Model Option for a database
  • Make the changes through the SSMS GUI or with scripts

Video Download

Length: 3 Minutes 24 seconds

Module 12: Demo 2

In this demonstration you will learn to:

  • Create a Maintenance Plan using SSMS
  • Schedule the plan for future execution
  • Use SQL Server Agent – Job Activity Monitor to monitor the execution status

Video Download

Length: 10 Minutes 46 seconds

Module 12: Demo 3

In this demonstration you will learn to:

  • Create a Tail Log backup
  • Restore a database to every committed transaction

Video Download

Length: 14 Minutes 3 seconds

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?