Home > Storage > PowerStore > Databases and Data Analytics > Dell PowerStore: Microsoft SQL Server Best Practices > T-SQL snapshot backup overview
SQL Server 2022 introduced Transact-SQL (T-SQL) snapshot backup, which allows array-based snapshots to be used for all common backup and restore scenarios. This includes point-in-time restores using differential backups and transaction log backups. This feature was implemented as extensions to existing T-SQL commands. Also, it works across all SQL Server platforms and does not require any additional components, such as Microsoft Volume Shadow Copy Service (VSS) provider. The Dell Technologies blog post SQL Server 2022 – Time to Rethink your Backup and Recovery Strategy covers some additional history and information about this new SQL Server 2022 feature.
The T-SQL snapshot backup feature allows PowerStore snapshots to be used as a primary option for all backup and recovery workflows, including disaster recovery, repurposing, and reseeding Always-On Availability Groups. This allows backup and recovery operations to be run in seconds, regardless of the database size.
The following workflow examples detail the process for performing T-SQL snapshot backup and restore on Windows. For Linux operating systems, the workflow is the same: simply substitute Windows disk commands with the appropriate Linux commands for mounting and unmounting file systems. For detail about the appropriate method for supported Linux distributions, see the Linux Host Connectivity Guide.