Implementing Database Backups, Recovery and Recovery Models Using SQL Server 2008

Register Login

Wednesday, June 19, 2013

MICROSOFT SQL SERVER COMMUNITY WORLDWIDE

Videos Database Backups and Recovery

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

SQL Server Educational Videos

1 Databases and Instances
1 Database Architecture
1  Advanced Architecture
1  SQL Server Objects
1  Managing SQL Server Data
1 Database Security
1 Basic DBA Duties
1 Concurrency Control
1 Managing SQL Objects
1 Securing and Auditing
1 Data Transfer Mechanism
1 Backups and Restores
1 Performance Tuning
1 Scalability & High Availability
1 Monitoring SQL Server

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

Privacy Statement

Terms Of Use