Microsoft SQL Server 2014 - Designing Solutions: Backup and Recovery


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
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

Prerequisites
None

Expected Duration (hours)
2.8

Lesson Objectives

Microsoft SQL Server 2014 - Designing Solutions: Backup and Recovery

  • 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
  • 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
  • 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
  • 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
  • configure SQL Server 2014 replication
  • validate a SQL Server 2014 replication configuration
  • Plan SQL Server Backup and Recovery

    • Course Number:
    md_ddsa_a06_it_enus

    Expertise Level
    Intermediate