Explore Microsoft SQL Server 2016 episodes

Topics include:

  • Microsoft services components that make up
    SQL Server 2016
  • Microsoft SQL Server Management Studio (SSMS)
  • Database and log files
  • Database recovery models
  • Microsoft VSS and Microsoft SQL Server 2016
  • Veeam® Explorer™ for Microsoft SQL Server

Topics include:

  • How Veeam protects databases and log files
  • Restores to point in time using Veeam Explorer for Microsoft SQL Server 2016
  • Restores to a specific transaction using Veeam Explorer for Microsoft SQL Server 2016
  • Starting SQL Server 2016 in the Veeam Virtual Lab

Topics include:

  • Database exclusions from backups
  • Transaction log management deep-dive
  • Performing database maintenance tasks using Veeam pre and post-scripts
  • Web interface for database self-service restores
  • Automatic recovery verification using Veeam SureBackup®

Speakers

Alexander Shelemin

Alexander is a developer at Veeam working on SQL Server database architecture and optimization. Before joining the R&D team, he worked as a technical support engineer at Veeam for two years, specializing in SQL Server‑related problems.

Martin Plesner-Jacobsen

Martin worked as a consultant for 13 years and has many years of experience in optimizing large customer solutions with business needs in mind. Martin focuses on Microsoft and VMware products and he holds certifications in many Microsoft and VMware technologies.

Veeam and Microsoft SQL Server 2016 — 101

The first video tutorial of the Veeam Microsoft SQL Server series will help you get started with SQL Server 2016. It will focus on basics such as SQL Server 2016 architecture, its key components and their functions.

In this video, our experts will explain how to configure your SQL Server 2016 correctly to avoid future headaches. You will learn why it's important to have multiple SQL Server 2016 instances, how to manage data and log files, and which tools you can use for SQL Server 2016 administration. A live demo will help familiarize you with Microsoft SSMS a primary SQL Server 2016 administration software. This video also covers Microsoft VSS basics and the specifics of database recovery models, backup types and restores to help you prepare for the further discussion on Availability for an SQL Server 2016. You will also learn how to restore and export an SQL database with Veeam Explorer for Microsoft SQL.

Veeam and Microsoft SQL Server 2016

As a data platform for business-critical applications, SQL Server requires the most reliable protection. This video tutorial — enriched with live demos — covers three main topics on SQL Server 2016 protection, including SQL transaction log management, restore options for Microsoft SQL Server databases and getting the most out of your SQL backups with the Veeam Virtual Lab.

You will learn how to configure SQL backup job settings in Veeam Backup & Replication, when to use the copy-only mode for SQL backups and how you can benefit from Veeam's full support for SQL Server availability groups. You'll see how to easily perform different restore scenarios for SQL databases with a live demo of Veeam Explorer for Microsoft SQL. And the tour around the Veeam Virtual Lab is the cherry on top of this episode! Our experts will explain how it works and present several scenarios that use the Veeam Virtual Lab for SQL backup recovery verification and software patches’ tests.

Veeam and Microsoft SQL Server — Deep - dive 2016

This episode wraps up our SQL Server 2016 course with a technical deep-dive on the SQL Server availability enabled by Veeam. It will show you how things work under the hood, so you can maximize your SQL Server 2016 protection.

Join our experts to learn about unique features of Veeam Backup & Replication, which helps to ensure Availability of your business's critical applications and services. Specifically, you will learn how you can granularly exclude SQL databases from your backups, troubleshoot issues with transaction log management and how to delegate database restores or perform a self-service restore. Additionally, in this video tutorial we will discuss using PowerShell scripts for Veeam SQL backup automation and SureBackup recovery verification.

Disclaimer: Although earlier versions of SQL Server and Veeam® Availability Suite™ were mentioned in this webinar, the information in the webinar is also applicable for SQL Server 2016 and Veeam Availability Suite 9.5.