Thursday, July 24, 2014
 
  Backup & Recovery Strategies

Implementing Backup and Recovery Strategies

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
  Understanding Recovery Models

Understanding Recovery Models

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






  Implementing Maintenance Plans

Implementing Maintenance Plans 


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

Implementing Database Backups and Recovery

In this module you will learn about backup and recovery methods available in Oracle and SQL Server 2008, types of failure, and types of recovery.

  Implementing Tail-Log Backups

Implementing Tail-Log Backups

In this demonstration you will learn to:

  • Create a Tail Log backup
  • Restore a database to every committed transaction
HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM