In my previous post, I showed you how to build a snapshot backup catalog using SQL Server 2025’s new native REST API integration. But what if you’re still running SQL Server 2022? Should you miss out on this powerful capability?
Absolutely not.
In this post, I’m going to show you how to achieve the same snapshot backup catalog functionality using PowerShell with SQL Server 2022’s T-SQL Snapshot Backup feature. While we don’t have the native REST integration yet, we can still leverage the power of FlashArray Protection Group Tags to build a queryable snapshot catalog that bridges the gap between database administration and storage management.