Episode

File-Snapshot Backups Demo

SQL Server 2016 introduces a new type of SQL Server backup for database files stored in Microsoft Azure blob storage. This new type of backup is called File-Snapshot backup and it leverages the storage snapshot capabilities of Azure blob storage to take nearly instantaneous backups and perform incredibly fast restores.

In this demo, you will see the performance difference when restoring to a point in time using traditional streaming backups versus using file-snapshot backups.

Additional resources: