Microsoft SQL Server 2014 – Designing Solutions: Backup and Recovery

Database professionals who design and build database solutions, create plans and designs for database structure, storage, objects and servers, and plan the environment in which the database solutions run

Prerequisite
None

Expected Duration
168 minutes

Description
Backup and recovery planning are key to any organizations who implement SQL Server 2014. This course covers backup and recovery, how to create and maintain a disaster recovery plan, and configuration and management of SQL Server replication. This course is part of a series of Skillsoft courses that covers the objectives for exam 70-465. This exam is required for the certification MCSE: Data Platform.

Objective

SQL Server 2014 Backup

  • start the course
  • recognize the various backup types available in SQL Server 2014
  • describe the different SQL Server 2014 recovery models
  • describe the different backup strategies available in SQL Server 2014
  • perform a backup of a SQL Server 2014 database
  • perform a backup of a SQL Server 2014 database to Azure Blob Storage

SQL Server 2014 Restore

  • describe the SQL Server 2014 restore process
  • recognize the process sequences for restoring SQL Server 2014 databases
  • restore a SQL Server 2014 database
  • restore a SQL Server 2014 database to a point in time
  • restore a SQL Server 2014 database from Windows Azure Blob Storage
  • backup and restore a Windows Azure SQL database

Disaster Recovery Planning

  • describe the considerations for creating a disaster recovery plan
  • describe the considerations for verifying a disaster recovery plan
  • describe the considerations for maintaining a disaster recovery plan

Replication Overview

  • describe SQL Server 2014 replication
  • describe SQL Server 2014 snapshot and transactional replication
  • describe SQL Server 2014 peer-to-peer transactional and merge replication
  • describe the function of agents in SQL Server 2014 replication
  • describe the considerations for security in SQL Server 2014 replication

Implementing Replication

  • configure SQL Server 2014 replication
  • validate a SQL Server 2014 replication configuration

Practice: SQL Backup and Recovery

  • Plan SQL Server Backup and Recovery

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.