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
WMV

Length: 21 Minutes 31 seconds

Downloads
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
WMV

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
WMV

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
WMV

Length: 14 Minutes 3 seconds