by Steve Jones | Released July 2017 | ISBN: 9781787281431

Safeguard your business continuity and database with the help of Backup, Automation, and Disaster RecoveryAbout This VideoGet real-world, practical content that helps you dive right into the maintenance and automation of SQL Server 2016Work with the latest features of the SQL Server 2016 releaseExplore important concepts such as backup strategy and disaster recoveryIn DetailMicrosoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. In this video tutorial, you will start with diving into Backup and Recovery of your Database. Here, you will learn to develop a backup strategy and carry out full database backups as well as differential database backups. You will explore the different options for restoring your system logs, and how to restore your database's state to a specified point in time. From there, you will move on to Automating your Server. You will learn to create tasks and jobs for your system, and also set up operations and notifications. You will also learn to configure alerts and database emails for sending messages to users. After that, you will dive right into High Availability and Disaster Recovery, where you will database mirroring, log shipping, and availability groups. Finally, you will explore the different types of server and data replication and how they are used. By the end of this video tutorial, you will be well versed with automating and maintaining your own database using SQL Server. Show and hide more

1. Chapter 1 : Backup and Recovery
   • The Course Overview 00:03:12
   • Backup Strategy 00:09:22
   • Full Database Backups 00:09:54
   • Differential Database Backups 00:04:58
   • Transaction Log Backups 00:04:27
   • Basic Database Restores 00:07:33
   • Restoring Transaction Logs 00:04:21
   • Restoring to a Point in Time 00:06:38
2. Chapter 2 : Server Automation
   • SQL Server Agent 00:08:53
   • SQL Agent Jobs 00:10:38
   • Job Schedules 00:06:07
   • Operators and Notifications 00:06:07
   • Alerts 00:06:32
   • Database Mail 00:07:01
3. Chapter 3 : High Availability and Disaster Recovery
   • Clustering 00:10:25
   • Availability Groups 00:13:11
   • Database Mirroring 00:11:11
   • Log Shipping 00:08:31
   • Replication 00:11:01
Show and hide more