Episode

Rethink your backup and recovery strategy with T-SQL Snapshot Backup in SQL Server 2022 | Data Exposed

with Anna Hoffman, Perry Skountrianos

In this Data Exposed episode with Anna Hoffman and Perry Skountrianos we will discuss the new capability in SQL Server 2022 that introduces new cross platform T-SQL commands to perform a snapshot backup of your user databases. We will cover the use cases to when database administrators and developers would want to leverage this capability, along with an end-to-end demo and usage considerations.

Chapters

  • 00:00 - Introduction
  • 01:20 - Storage snapshots and SQL Server
  • 02:00 - Snapshot backup (single database)
  • 03:30 - Demos

Connect

Data Scientist
Data Engineer
Data Analyst
Database Administrator
Azure
Azure SQL Database
SQL Server
SQL
Transact-SQL