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.
Learning Objectives
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