Microsoft Developer presents how SQL Server 2025 integrates with Pure Storage FlashArray to create a self-documenting, metadata-rich backup snapshot catalog, covering automation and metadata embedding directly from T-SQL.

Building a Snapshot Backup Catalog with SQL Server 2025 and Pure Storage FlashArray

Learn how to use SQL Server 2025’s new native REST API features alongside Pure Storage FlashArray’s advanced snapshot tagging capabilities to revolutionize backup management and cataloging.

Key Takeaways

  • Automated Snapshot Creation: Leverage SQL Server 2025’s sp_invoke_external_rest_endpoint stored procedure to initiate and manage snapshot creation directly from T-SQL without needing external backup scripts or tools.
  • Metadata-Rich Snapshots: Embed detailed metadata, such as database name, SQL instance, backup timestamp, backup type, and backup URL, directly into each snapshot. This ensures every backup snapshot is self-describing and easy to manage.
  • Queryable Backup Catalog: Treat snapshots as searchable data assets. You can query your backup catalog by database, instance, time range, or any metadata tag combinations, providing quick insights and improving backup discoverability.
  • Consistent and Portable Backups: By tagging snapshots as copyable, all embedded metadata remains intact even when replicating snapshots across arrays, data centers, or to the cloud, enhancing backup portability and compliance.

How It Works

  1. Integrate SQL Server 2025 with FlashArray
    • Use the new sp_invoke_external_rest_endpoint T-SQL procedure to call the FlashArray REST API.
    • Automate snapshot creation and apply metadata tags from within SQL Server, improving consistency and transparency.
  2. Embed Metadata for Self-Documentation
    • Metadata (database, instance, timestamp, backup type) is added to each snapshot at the time of creation.
    • Snapshots are searchable and filterable by any combination of these metadata attributes.
  3. Enable Snapshot Portability
    • Protection Group Tags travel with the snapshot, ensuring metadata is not lost when snapshots are moved or replicated between storage environments.

Practical Demo Highlights

  • Real-World Scenario: Step-by-step demonstration of snapshot creation, tagging, and querying with SQL Server 2025 and FlashArray.
  • T-SQL Automation: Sample scripts show how to invoke REST APIs and manage tags from SQL statements.
  • Querying and Cataloging: Examples of using T-SQL to search and catalog snapshots based on tags and metadata, making backup management streamlined.

Additional Resources

Discover how SQL Server 2025 and Pure Storage FlashArray can make backup management smarter, more reliable, and adaptable across your environments.