~/talk

SQL Server 2022 – Time to Rethink your Backup and Recovery Strategy

on YouTube 21m
Talkat SQLBits 2022 · 2022-03-08..03-12· [databases, cloud-infrastructure]

speakers

name:Stephen McMaster
links:none on file
name:Robert Sonders
links:none on file

resources

video:https://youtu.be/YZfYqxWsvdk
slides:none on file

summary

SQL Server 2022 adds a T-SQL snapshot backup that coordinates hardware snapshots (PowerStore and other SANs) via CLI or PowerShell, produces a small BKM metadata file instead of a full .bak, auto-unfreezes on success, and supports mounting the snapshot then rolling transaction logs forward to a point in time. It also writes directly to S3-compatible object stores (Dell ECS), shrinking nightly backups, and in a demo joins external parquet data — 200 million rows in 15–20s — which validates the approach.

AI-written summary · about

chapters (6)

  1. 0:00Introduction and context
  2. 3:03SQL Server snapshot backups
  3. 7:27Restoring and management
  4. 9:24Object storage integration
  5. 14:03Modern architecture shifts
  6. 18:24Availability and closing

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.