SQL Server 2022 – Time to Rethink your Backup and Recovery Strategy
summary
Showcases Transact-SQL snapshot backup on SQL Server 2022 that freezes writes, generates a readable BKM metadata file, and lets T‑log rollforward from a hardware snapshot; demos mount snapshots, restore to new volumes, and run cleanup with seven–ten day retention. Uses Dell storage snapshots (PowerStore and ECS), orchestration via PowerShell, and S3 object storage integration that offloads large read‑only tables. A demo joins 200 million parquet rows in object storage and returns results in ~15–20 seconds, proving the approach both performant and practical.
AI-written summary · about
chapters (6)
- 0:00Introduction and context
- 3:03SQL Server snapshot backups
- 7:27Restoring and management
- 9:24Object storage integration
- 14:03Modern architecture shifts
- 18:24Availability and closing
related talks
21mSQL Server 2022 – Time to Rethink your Backup and Recovery Strategy
49mPerformance Improvements in SQL Server 2019
50mSQL Server 2022 Performance Enhancements
54mSoaring to New Heights with Accelerated Database Recovery- 50mSQL Server 2022 Performance Enhancements
50mSQL 2022 and S3 – Dell’s overview of consuming object data via Microsoft SQL
50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
47mDisaster Recovery Strategies for SQL Server